Update Table By ID Ranges

[Mike Doanh Tran]

Hi,

How do i use the UPDATE statement to update a range of Primary Key id 
numbers. (let say 100 through 1000).

Example,

UPDATE testTable set testField='9999' WHERE
test_id in (100:1000);

Thanks in advance for any comments,

Mike


 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]