Re: newbie sequel question: how do we search for multiple things on 1 field like:

[Rick Dwyer <rpdwyer@xxxxxxxxxxxxx>]

SELECT * FROM contacts WHERE state = 'CA' and (name = 'bob' or name =  
'sam' or name = 'sara')

 --Rick


On Jun 18, 2010, at 4:30 PM, Dave wrote:

> SELECT * FROM contacts WHERE state = 'CA' and  ???? name = 'bob' or
> name = 'sam' or name = 'sara' ????
>
> --
> Thanks - Dave
>
> --
> 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