Re: newbie sequel question: how do we search for multiple things on 1 field like:
| From: | Daniel Brown | Date: | Fri, 18 Jun 2010 20:40:50 +0000 |
| Subject: | Re: newbie sequel question: how do we search for multiple things on 1 field like: | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-306253@lists.php.net to get a copy of this message | ||
On Fri, Jun 18, 2010 at 16:30, Dave <dealtek@gmail.com> wrote:
> SELECT * FROM contacts WHERE state = 'CA' and ???? name = 'bob' or
> name = 'sam' or name = 'sara' ????
We begin by asking on the right list (mysql@lists.mysql.com, CC'd
by courtesy).
You're on the right track though. Try a WHERE...IN statement:
SELECT * FROM contacts WHERE state='CA' AND name IN
('bob','sam','sara');
--
</Daniel P. Brown>
daniel.brown@parasane.net || danbrown@php.net
http://www.parasane.net/ || http://www.pilotpig.net/
We now offer SAME-DAY SETUP on a new line of servers!