Here's my question. I wrote this query:
Select * FROM name WHERE last LIKE "d" AND choice1="2" OR choice2="2" OR
choice3="2";
What I'm looking for are records that satisfy the LIKE "d" condition
But then, Only one of the three other conditions need be true:
choice1=2
choice2=2
choice3=2
I want to cover the possibilities, e.g.,
choice1=2
choice2=1
choice3=1
choice1=1
choice2=2
choice3=whatever
Or
choice1=1
choice2=1
choice3=2
Does this make sense? The query I've written doesn't seem quite right.
Because of the AND following the LIKE "d" condition, it seems like all
the records will have to have choice2 equaling 2.
Some help clarifying this issue would be appreciated. Thanks.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production services for the web
Put creative minds to work for you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
