[SOLVED] Searching a database

[ecopetition]

Hello,

 

I'm trying to search a database with table X using the following query, where $search_query is the inputted search string and Y and Z are two columns.

 

$sql = "SELECT *
FROM X
WHERE Y
LIKE ($search_query)
ORDER BY Z DESC";

 

This code works fine, but returns a result only when Y is EQUAL to the search query, rather than when Y only just includes the search query somewhere.

 

Does anyone have a clue what's wrong or what I can do you fix this?

 

Thanks, Peter

[Push Eject]

$sql = "SELECT *

FROM X

WHERE Y

LIKE '%$search_query%'

ORDER BY Z DESC";

[ecopetition]

Brilliant, thanks a lot.