i have three fields of name in database named as fnam,mname,lname. fname and lname is mandatory field and mname is optional.
i want to make a search query on name
Expand|Select|Wrap|Line Numbers
- mysql_query("SELECT * FROM abc where CONCAT(fname,' ',mname,' ',lname) like'" . $q . "%' order by id");
on the other case when i write
Expand|Select|Wrap|Line Numbers
- mysql_query("SELECT * FROM abc where CONCAT(fname,' ',mname,'',lname) like'" . $q . "%' order by id");
please provide me some solution. can i use if condition in concat?
i need to know if i am not clear in my question