[snip] When I run the follow query: DELETE FROM table WHERE client_id = 1 AND row_id IN (2,5,7)
only the first record is deleted. Am I doing something wrong or is it a MySQL bug? [/snip] It is not a bug, just say it out loud.... "AND row_id is 2 OR 5 OR 7" Once the OR condition is satisfied once, the query will halt. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
