This updates all products to live status (1) in the column ProductLive whose ID is between 2596 and 3029
UPDATE products SET ProductLive = 1 WHERE products.ProductID >2596 LIMIT 3029
How to update multiple rows of your MySQL database by selecting ID range
March 27, 2013