My LIKE in sql queries isn't working as I excepted, I'm not good with sql so any help would be great!
I run this query
SELECT * FROM people WHERE readers > '0' AND subscribers > '0' AND minValue < '5' AND about LIKE '%40%' AND country=1 OR country=2
It must only return where people in the about field has the value 40 somewhere. The problem is it returns all of them as if the LIKE caluse isn't present?
I'm not sure why when I just run
SELECT * FROM people WHERE about LIKE '%40%'
It does only return the ones it should