it could better be like
SELECT * FROM list WHERE name in ('$this1', '$this2', '$that1')
Nitin
----- Original Message -----
From: "Colleen Dick" <platypus@stripped>
To: "Mike At Spy" <spycobalt@stripped>
Cc: <mysql@stripped>
Sent: Thursday, October 16, 2003 10:14 AM
Subject: Re: OR in MySQL statement?
> Mike At Spy wrote:
> >
> > How could I write a statement that uses something like 'OR' as a case.
Like
> > this:
> >
> > SELECT * FROM list WHERE name = '$this1' OR name = '$this2' OR name =
> > '$that1'
> >
> > ?
> >
> > Thanks for any help,
> >
> > -Mike
> >
> >
> >
>
> ummmm.... just like that looks good to me.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>
