On Fri, Jun 18, 2010 at 16:30, Dave <deal...@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.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ We now offer SAME-DAY SETUP on a new line of servers! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org