You can do it exactly like that, or you could use the IN() syntax if
you have a large number of values to check.
SELECT * FROM list WHERE name IN('$this1', '$this2', '$this3')
- Gabriel
On Wednesday, October 15, 2003, at 04:16 PM, 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
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
