You should direct such queries to the MySQL mailing list as this is a PHP list.
[EMAIL PROTECTED] or try their website: www.mysql.com Your answer however is here: http://www.mysql.com/doc/en/SELECT.html ----- Original Message ----- From: "Richard Kurth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 16, 2003 4:30 PM Subject: [PHP] Help with where clause I need to know how I can do a where clause in a select statement for mysql where one of the fields can have two solutions. In the example below field3 needs to equal all with a and also all with b. Can this be done and if so how. I am stumped on this one. select * from table where field1= '$this' and field2 = '$that' and field3 = 'a and b' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
