How to update multiple rows of your MySQL database by selecting ID range

By Chris on March 27, 2013 in php

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

About the Author

ChrisView all posts by Chris >


Leave a reply

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.