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

By Chris on March 27, 2013 in php
0
0

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 >

0 Comments

Leave a reply

Leave a Reply

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