On Tuesday, April 24, 2007 10:12 AM Jim Winstead <mailto:[EMAIL PROTECTED]> said:
>> AND `type` = 0 >> AND `manager_id` = 0 >> AND `modified` = NOW() >> WHERE `id` = 5 > > you can't use 'AND' to connect your updates, you need to use commas: > > UPDATE users SET name = 'First Last', email = '[EMAIL PROTECTED]', > ... > > what you're doing now is setting your name column to a boolean > expression. Oops. :) Thanks a lot. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]