How to update multiple rows of your MySQL database by selecting ID range
By Chris on March 27, 2013 in php
0
1
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
0 Comments
Leave a reply
Leave a Reply
You must be logged in to post a comment.