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

On Fri, Jun 18, 2010 at 17:06, deal...@gmail.com wrote: > > I will start using this... > >   We begin by asking on the right list (my...@lists.mysql.com, CC'd > by courtesy). It was just an end-of-the-week jab, Dave. I mean, that's the correct list to use, but the response should've had a to

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

Thanks Daniel and Rick! I will start using this... We begin by asking on the right list (my...@lists.mysql.com, CC'd by courtesy). Thanks, Dave deal...@gmail.com [db-10] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

On Fri, Jun 18, 2010 at 16:30, Dave wrote: > SELECT * FROM contacts WHERE state = 'CA' and   name = 'bob' or > name = 'sam' or name = 'sara' We begin by asking on the right list (my...@lists.mysql.com, CC'd by courtesy). You're on the right track though. Try a WHERE...IN statem

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

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 Lis

[PHP] newbie sequel question: how do we search for multiple things on 1 field like:

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