shan_cool Posted November 16, 2005 Share Posted November 16, 2005 Hi all, I hav two fields namely,Emp_Fname and Emp_Lname.... in mysql. i would like to concatenate while displaying them Select Emp_Fname||Emp_Lname as Employee_Name from ...... but its not working. tell me how to concatenate and make them a single field to display. Thx in advance, Shan Quote Link to comment https://forums.phpfreaks.com/topic/2870-to-concatenate-two-fields-in-mysql/ Share on other sites More sharing options...
sumitnice@rediffmail.com Posted November 16, 2005 Share Posted November 16, 2005 Do this SELECT CONCAT(Emp_Fname, " ", Emp_Lname) from [table name] BEST OF LUCK With Regards, Sumit Quote Link to comment https://forums.phpfreaks.com/topic/2870-to-concatenate-two-fields-in-mysql/#findComment-9674 Share on other sites More sharing options...
shan_cool Posted November 16, 2005 Author Share Posted November 16, 2005 hi sumit, thank u verymuch for ur reply....... do keep in touch... bye for now shan.. Quote Link to comment https://forums.phpfreaks.com/topic/2870-to-concatenate-two-fields-in-mysql/#findComment-9675 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.