concatinate two columns in query

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
fitchic77
Forum Commoner
Posts: 51
Joined: Thu Jul 20, 2006 11:57 pm

concatinate two columns in query

Post 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!
Last edited by fitchic77 on Sat Oct 16, 2010 11:26 am, edited 1 time in total.
User avatar
Jenk
DevNet Master
Posts: 3587
Joined: Mon Sep 19, 2005 6:24 am
Location: London

Post by Jenk »

Have a look for CONCAT() on this page: http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html
Post Reply