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
        [EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to