Lack of abillity to read the manual.

See also rtfm.
< 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.
by BlueEagle May 30, 2006
Get the manual deficiency mug.
Lack of abillity to read the manual
< 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
by BlueEagle May 28, 2006
Get the manual deficiency mug.