select

hello

what's wrong with the following:
SELECT * from x WHERE (a OR b) = 'y' AND something='else'

what happens is that neither a nor b seem to be checked against y...
what's the correct and working way?

thanks in advance.

SELECT * FROM x WHERE y IN ('a', 'b') AND something='else'

The above would check for the values a OR b in field y AND that something equals else.

You can check out this link posted by philipolson for more regarding mysql's IN http://sqlcourse2.com/setoper.html

Was that what you were looking for?

Cgraz

i noticed this option on the board but thnaks for pointing it out. but could wildcard characters (ie %) be used with this as in LIKE?

veikko

I couldn't tell you for sure, I'd just suggest trying it and seeing if it works.

Let me know if it does.

Cgraz