Re: OR in MySQL statement?

[Dan Nelson]

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