Andrew Martin wrote:
Hello,
Is it permissible to order a clause such that the search term is the
first item (in the clause)?
standard:
field1 IN (123, 654, 789)
in question:
123 IN (field1, field2, field3)
I am interested to know if the optimizer treats this any differently
if anybody can shed any light on it (except for the obvious difference
in the above queries!)
Thanks,
Andy
Both are valid syntax where 1 is returned if the expression is equal to
any of the values in the list. I can't see the optimizer treating these
any differently.
Thanks,
Gary M. Josack
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]