On Wed, May 27, 2009 at 6:43 AM, Simon J Mudd <sjm...@pobox.com> wrote: > So is the format of the DELETE FROM .. WHERE ... IN ( ... ) clause I > propose valid and SHOULD the optimiser recognise this and be expected > to just find the 2 rows by searching on the primary key?
Not according to the docs: http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html#function_in - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org