Using concat to return 2 (or more) MySQL fields as one

– 16/05/2011Posted in: MySQL

If you have field one and field two but need to return them as a single new field then you need concat:

$sql = "concat(fieldone, ' (', fieldtwo,')') as newfield FROM table";

This example when echoing newfield will display fieldone (fieldtwo)

Like this? Maybe you could buy me a coffee.

Tags: concat, MySQL

Web Developer based in the UK. Click here if you want to work with me

Start the ball rolling by posting a comment on this article!

Buy me a coffee

Found anything useful? Maybe you could buy me a coffee
Spammers!

If you are going to put nonsense comments on my articles at least have the decency to click one of these adverts while you are here.

Even if you are a regular visitor you click a couple of ads while you are here - you might find something you want.
You May Also Like…
Cloud
accessibility block browser cache chrome chunk cms concrete5 CSS curl database date error file firefox form get href ie image input iphone javascript JQuery link magento MODx myqsl MySQL php post profile Revolution select Server session snippet spellcheck spelling table textarea tinymce w3c wordpress xml
Info

Yes, the images are ambiguous;
Yes, they came from Google images;
No, I didn't get permission to use them*;
I know Magento called isn't Magneto;

And...
Why do spammers who hit this site do it with such a bizarre use of the English language?;