From: Dan Nelson
Date: October 15 2003 8:25pm
Subject: Re: OR in MySQL statement?
List-Archive: http://lists.mysql.com/mysql/151715
Message-Id: <20031015202548.GJ39271@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Oct 15), Mike At Spy said:
> 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'

Exactly like you wrote it.  You can also use WHERE name IN ('this1', 'this2',
'this3'), which is a bit shorter.

-- 
	Dan Nelson
	dnelson@stripped