[SOLVED] Help Me Modify this MySQL Query

[webref.eu]

Hi All

 

I have the following MySQL query: 

 

$query = "select * from Products where (ProductName like \"%$trimmed%\" or ProductBrand like \"%$trimmed%\")  order by ProductName";

 

I want to modify it to include an or ProductDesc like \"%$trimmed%\, so how do I do this? 

 

Thanks

[webref.eu]

I tried changing it to this: 

 

$query = "select * from Products where (ProductName like \"%$trimmed%\" or ProductBrand like \"%$trimmed%\ or ProductDesc like \"%$trimmed%\")

 

but it doesn't like that. 

 

Rgds

[Alex]

$query = "select * from Products where (ProductName like \"%$trimmed%\" or ProductBrand like \"%$trimmed%\" or ProductDesc like \"%$trimmed%\");

[Maq]

You don't need parentheses or to escape the double quotes.  The conventional way is to use single quotes around the pattern.

 

  $query = "SELECT * FROM Products where ProductName LIKE '%$trimmed%' or ProductBrand LIKE '%$trimmed%' or ProductDesc LIKE '%$trimmed%'";

[webref.eu]

You don't need parentheses or to escape the double quotes.  The conventional way is to use single quotes around the pattern.

 

Thanks, changing as you suggested made it work. 

 

Thanks for the other reply too. 

 

Rgds