how about UPDATE testTable set testField='9999' WHERE test_id >= 100 and test_id <= 1000;
Mike Doanh Tran wrote: > > 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] -- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6 http://www.predict.com Santa Fe, NM 87505 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]