question about mysql_query

Codes here !

Moderators: macek, egami, gesf

New php-forum User
New php-forum User
Posts: 1
Joined: Thu Jun 07, 2012 5:20 am

question about mysql_query

Postby cledus » Thu Jun 07, 2012 6:09 am


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!

User avatar
New php-forum User
New php-forum User
Posts: 86
Joined: Mon Jun 04, 2012 10:05 pm
Location: Ankara, Turkey

Re: question about mysql_query

Postby ejsexton82 » Thu Jun 07, 2012 10:32 pm

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%%';",

Return to “mySQL & php coding”

Who is online

Users browsing this forum: Baidu [Spider] and 6 guests