List:General Discussion« Previous MessageNext Message »
From:Nitin Date:October 16 2003 8:20am
Subject:Re: OR in MySQL statement?
View as plain text  
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
>


Thread
OR in MySQL statement?Mike At Spy15 Oct
  • Re: OR in MySQL statement?Gabriel Ricard15 Oct
  • Re: OR in MySQL statement?Dan Nelson15 Oct
  • Re: OR in MySQL statement?Colleen Dick16 Oct
  • Re: OR in MySQL statement?Nitin16 Oct