On Thursday, December 04, 2003 6:22 PM CET, Martijn Tonies wrote: > Cause the WHERE clause only works on columns. If you want to > do a match on the result of the CASE, you have to do your case > thingy again: > > WHERE ( case ...yourstuff... end ) = 'something'
Wouldn't HAVING help here? -- Yves Goergen [EMAIL PROTECTED] Please don't CC me (causes double mails) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]