Mysql CONCAT function

by Sasikumar 2014-05-26 16:22:16

MySQL CONCAT function :
SELECT CONCAT(first_name, " ", last_name) as Name FROM user_details;

Table Structure with Data :
Table name : user_details
Id first_name last_name
1 Sasi Kumar
2 Mohan Kumar
3 Guru Prasath
4 Satheesh Kumar
Output:
Name
Sasi Kumar
Mohan Kumar
Guru Prasath
Satheesh Kumar
1438
like
0
dislike
0
mail
flag

You must LOGIN to add comments