From: Perrin Harkins Date: May 27 2009 12:02pm Subject: Re: Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key? List-Archive: http://lists.mysql.com/mysql/217705 Message-Id: <66887a3d0905270502p17a45484u41297296e6f33e2@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Wed, May 27, 2009 at 6:43 AM, Simon J Mudd wrote: > So is the format of the DELETE FROM .. WHERE ... IN ( ... ) =A0clause 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_i= n - Perrin