Difficult SQL question

[Pellefant]

Hello!

I have problem with this SQL query.

Also rows where approved=0 (approved is 0 or 1 in the db field) is found, why is that please?

[kod]
SELECT * FROM table1 WHERE artist LIKE '%$searchon%' OR title LIKE '%$searchon%' AND approved=1 ORDER BY artist;
[/kod]

[iceiceboom]

Well, with SQL, the OR statement, separates it into sections. So one side of yoru OR is looking for only 1 thing, while the other side is looking for 2 things.

Here is the corrected syntax:

SELECT * FROM table1 WHERE artist LIKE '%$searchon%' AND approved=1 OR title LIKE '%$searchon%' AND approved=1 ORDER BY artist;

[Pellefant]

Thanks a lot for the help and explanation. 🙂