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);
> how about > > UPDATE testTable set testField='9999' WHERE > test_id >= 100 and test_id <= 1000;
or just: expr BETWEEN min AND max http://www.mysql.com/doc/en/Comparison_Operators.html#IDX1156
-- Sebastian Mendel
www.sebastianmendel.de www.tekkno4u.de www.nofetish.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
