Page 1 of 1

concatinate two columns in query

Posted: Wed Aug 30, 2006 8:14 am
by fitchic77
How is this done in MYSQL. I can't figure it out. In oracle it is this:

Select fname || lname as name from users

Any help would be greatly appreciated!

Posted: Wed Aug 30, 2006 8:19 am
by Jenk
Have a look for CONCAT() on this page: http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html