Welcome to WebmasterWorld, quackman.

Yes, you can use operators such as LIKE in your WHERE clause.

Thank you for your quick response.

Sorry about the typo when I typed "waterfights", I meant "water fights". I think this may have confused the issue. "Like" does not get me to where I need to go.

I can select facilities that have parties or water fights with a simple or statement. However that doesn't always give me facilities that have both. It may provide me with facilities that only have one of the two uses.

If I use an and statement, it will always fail because "used_for" cannot equal 2 different values in the same row.

What I need is to be able to find 2 rows where the facilities are the same (i.e. abc) and the used_for in row x is "parties" and used_for in row y is "water fights"

SELECT 
 *
FROM 
 MyTable
WHERE
 Facility = 'abc'
 AND (used_for ='parties' OR used_for ='water fights');

That query returns facilities that have one or the other or both. I only want the ones that have both.

SELECT *
FROM MyTable
WHERE Facility IN (SELECT Facility FROM MyTable WHERE used_for = 'parties') AND Facility IN (SELECT Facility FROM MyTable WHERE used_for = 'water fights')

Awesome.. Thanks everyone. That is exactly what I was looking for.

Maybe throw a DISTINCT on that query as well.

I am not sure of your data but it may be possible that a duplicate rows can be returned with that query.

[edited by: Demaestro at 5:05 pm (utc) on Mar. 11, 2009]