Searching with Fname + Lname

[eluser]mexor[/eluser]
I didn't realize it but my search doesn't work correctly. If theres someone named John Candy it will find you if you type in "John" or "Candy" but not if you type in "John Candy".

I'm just using this SQL call:
$query = $this->db->query("SELECT * FROM registered WHERE fname LIKE '%$q%' OR lname LIKE '%$q%' ORDER BY lname ASC");

So clearly it won't get it if the Q is "fname lname" ... How do I get my search to find that too?

-Dave

[eluser]xwero[/eluser]
i'm not sure if it's going to work but you could try

SELECT * FROM registered WHERE CONCAT_WS(' ',fname,lname) LIKE '$q' OR fname LIKE ‘%$q%’ OR lname LIKE ‘%$q%’ ORDER BY lname ASC

[eluser]mexor[/eluser]
nope, that didn't do it... =(

[eluser]xwero[/eluser]
I've just tested it with CONCAT_WS(’ ‘,fname,lname) LIKE ‘$q’ and CONCAT_WS(’ ‘,fname,lname) = ‘$q’ and it found the full name.