manual deficiency
Lack of abillity to read the manual.
See also rtfm.
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.
< 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.
manual deficiency
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
< 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