Help with where clause
| From: | Richard Kurth | Date: | Tue, 16 Dec 2003 08:30:22 +0000 |
| Subject: | Help with where clause | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-172779@lists.php.net to get a copy of this message | ||
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'