< aKa> MySQL question: I want to take two varchar fields and return it as one column. My guess was : SELECT (first_name + " " + last_name) as full_name FROM table
< BlueEagle> SELECT CONCAT (last_name,', ',first_name) AS full_name FROM mytable
< BlueEagle> http://dev.mysql.com/doc/ refman/5.1/en/select.html <= To help with your manual deficiency.

I've been jabbed

< aKa> MySQL question: I want to take two varchar fields and return it as one column. My guess was : SELECT (first_name + " " + last_name) as full_name FROM table
< BlueEagle> SELECT CONCAT (last_name,', ',first_name) AS full_name FROM mytable
< BlueEagle> http://dev.mysql.com/doc/ refman/5.1/en/select.html <= To help your lack of manual deficiency