Hello, I am running MySQL version 3.23.39 on a Mac running OS X 10.2.4
This query works without error: Drop table if exists temp; create temporary table temp select @canread := "false", @canread := if(Institution_Id = "8","true","false"), @canread AS canread from persons; select * from temp; This query works without error: select @canread := "false", @canread := if(FIND_IN_SET("8", Institution_Id) > 0,"true","false"), @canread AS canread from persons; This query doesn't: Drop table if exists temp; create temporary table temp select @canread := "false", @canread := if(FIND_IN_SET("8", Institution_Id) > 0,"true","false"), @canread AS canread from persons; select * from temp; I get the error: ERROR 1166: Incorrect column name '@canread := if(FIND_IN_SET("8", Institution_Id) > 0,"true","false")' Can anyone tell me why? Barbara Gelhard --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php