[snip] This does not work. It appears that the user variable is not picked up in the WHERE clause - the query works fine if I have: [/snip]
You have a fundamental lack of understanding of user variables. A quick read of http://dev.mysql.com/doc/mysql/en/Variables.html will reveal "User variables may be used where expressions are allowed". -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]