Re: simple query

[Rick James]

You are still making up syntax, this time is how expressions are formed. This may appear to work, but it does not do what you think:

WHERE col = 'x' OR 'y' OR 'z'

You need

WHERE col = 'x' OR col = 'y' OR col = 'z'

Or you could say it:

WHERE col IN ('x', 'y', 'z')

The first one is parsed as

WHERE (col = 'x') OR ('y') OR ('z')

The risk is the ('y') treats the string 'y' as TRUE and selects more rows than you expect !