sniperscope Posted October 21, 2011 Share Posted October 21, 2011 Hi, I have a table which is holding person name as Firstname, Lastname, Middlename, Fathername But i have only one input area in my form. So, how can i search all those columns with a single text? I hope i made my self clear. Quote Link to comment https://forums.phpfreaks.com/topic/249502-query-multiple-columns/ Share on other sites More sharing options...
sniperscope Posted October 21, 2011 Author Share Posted October 21, 2011 Problem solved. Here is solution. Hope this help someone else CONCAT(Firstname, Lastname, Middlename, Fathername) LIKE '%something_search_string%' Quote Link to comment https://forums.phpfreaks.com/topic/249502-query-multiple-columns/#findComment-1281027 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.