I'm sure the answer is "You're SOL", but I figured I'd ask anyway. I have a WHERE condition like:
SELECT * FROM a JOIN b WHERE (b1 IS NULL OR b1 = u1) AND (b2 IS NULL OR b2 = u2) AND (b3 IS NULL OR b3 = u3) where b is a Very Large table. I have an index on b like (b1, b2, b3), but obviously that gets thrown out because of the OR. Is there a Better Way to either rewrite the WHERE condition or break out b to allow indexes to be used? ____________________________________________________________ Eamon Daly -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
