it could better be like
SELECT * FROM list WHERE name in ('$this1', '$this2', '$that1')Nitin ----- Original Message ----- From: "Colleen Dick" <[EMAIL PROTECTED]> To: "Mike At Spy" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
