How to query the same table for more than one possible results

[fran7]

Hi,
I wonder if anyone can tell me how to write this query properly as this one doesnt work.

where tbl.gallery='Abstract' and tbl.gallery='Abstract art'

Need to query the same table for the results that match the two possible results.

Thanks in advance
Richard

[Jerry Winston]

This is kind of a data questions. I think the syntax you're looking for is OR.

tbl.gallery='Abstract' OR tbl.gallery='Abstract art'

[jhardman]

alternatively,

tbl.gallery in ('Abstract','Abstract art','Modern art')

Jared

[NeoPa]

What you have to understand Richard, is that an AND in the WHERE clause is not saying :

Get me :
All records where {first check}
AS WELL AS 
All records where {second check}

Rather, it is saying :

Get me all records where {first check} AS WELL AS {second check}

Thus, records are only selected when both checks succeed.

You need to use the OR conjunction instead as has already been said by Jerry.

For more flexibility use the IN() function (as per Jared's post). Two checks is fine with OR but going beyond that is better with IN().

[ck9663]

I'll throw a wrench :)...

If you're using an OR in any of your condition, place the most probable TRUE condition first. If you're using an AND, place the most probable FALSE condition first.

This way, a complicated condition need not be test throughout. In OR, only one of the condition needs to be TRUE to make the entire condition as TRUE. In an AND, only one condition needs to be FALSE to make the entire condition as FALSE.

Although it's not always 100% that the server will parse the condition from left to write, it usually do.

Happy Coding!!!

~~ CK