question about mysql_query

[cledus]

Hello!

I just started looking at php and mysql. I ran into a small problem. I would like to extract data like this: $queryPerson = 'SELECT * FROM persons WHERE pFirstName LIKE "%'.$searchQuery.'%" OR pLastName LIKE "%'.$searchQuery.'%" OR pFirstName." ".pLastName LIKE "%'.$searchQuery.'%"';

I understand that I can't wright like this: OR pFirstName." ".pLastName LIKE "%'.$searchQuery.'%"';

Can I write it in any other way?
Grateful for any help!

[ejsexton82]

You can use the CONCAT() function:

Code: Select all

$queryPerson = 'SELECT * FROM persons WHERE '
   . sprintf("pFirstName LIKE '%%%s%%' ", mysql_real_escape_string($searchQuery))
   . sprintf("OR pLastName LIKE '%%%s%%' ", mysql_real_escape_string($searchQuery))
   . sprintf("OR CONCAT(pFirstName,' ',pLastName) LIKE '%%%s%%';",
      mysql_real_escape_string($searchQuery));