On Tue, Apr 24, 2007 at 10:03:58AM -0700, Chris W. Parker wrote: > UPDATE `users` > SET `name` = 'First Last' > AND `email` = '[EMAIL PROTECTED]' > AND `balance` = 0 > AND `accrual` = 14400 > AND `is_manager` = 1 > AND `is_superadmin` = 1 > 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. jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]