MySQL query which has LIKE and AND clause

I have the following query:\[code\]$query="SELECT * FROM products WHERE productname LIKE '%$searchterm%' OR shortdescription LIKE '%$searchterm%' OR description LIKE '%$searchterm%' AND VISIBLE != 0";\[/code\]The query returns records that i want, but also returns records which has visible = 0. Can anyone tell me what i am doing wrong?Regards,Zoran
 
Back
Top