[SOLVED] SQL Order Of Operations in "AND" and "OR" operators

[jjacquay712]

I have a php script that generates search querys. The generated query looks like this when i enter the search term "test", and "search":

 

SELECT title,description,link FROM search WHERE title like '%test%' or description like '%test%' or link like '%test%' and title like '%search%' or description like '%search%' or link like '%search%'

 

My problem is that it always returns a result even if the second AND statement is evaluated false. I have talked to a few people about this and they said my "order of operations" are wrong in the query. Can someone explain how i could do the query different to get the desired results?

[AndyB]

Asked and answered

 

http://www.phpfreaks.com/forums/index.php/topic,219441.msg1005766.html#msg1005766

 

Please DO NOT double post.  Thread closed.