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.
Prices shown in USD.
Type your email address below to get our free Urban Word of the Day every morning!
Emails are sent from firstname.lastname@example.org. We'll never spam you.