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]