Multiple LIKE statements

melkin · #1 (**permalink**) July 28th, 2008, 02:02 PM

Hello Programmer Gurus!
I am trying to query my databsse of 10 ten fields for a search page.
When I use:
Model1 like '" & Search & "%' AND Model2 like '" & Search & "%'AND AND Model2 like '" & Search & "%'

I only get results from the first like statement. I know I have matching criteria in the other fields. any ideas??

melkin · #2 (**permalink**) July 28th, 2008, 02:05 PM

Actually my error from above! I get NO results! but if I remove the last "Like" statement, The first one works fine!????

melkin · #3 (**permalink**) July 28th, 2008, 02:07 PM

Ahhhhhhhhhhhh!

Sorry!
Model1 like '" & Search & "%' AND Model2 like '" & Search & "%'AND Model2 like '" & Search & "%'

Above had an extra "and".... Still doesnt work though.

GreenCore · #4 (**permalink**) December 17th, 2008, 03:38 PM

Select * FROM tablename WHERE (columnname1 like ('%ValueA%')) OR (columnname2 not like ('%ValueB%')) limit 10;

Good luck!

Need to download code?

Navigation