Guest Posted September 5, 2010 Posted September 5, 2010 Hi Everyone, I was hoping some kind hearted soul could help me. Basically I have setup a store with every item at £15. I now want to change every item to £13. Is there some quick MySQL query code I can type in like REPLACE 'products' where 'product_price' = 15 TO 'products' where 'product_price' = 13 Cheers in advance :) Michael
chadcloman Posted September 5, 2010 Posted September 5, 2010 UPDATE products SET products_price = '15' WHERE products_price = '13' or, if you're sure that every product has the same price: UPDATE products SET products_price = '15' Check out Chad's News.
Guest Posted September 6, 2010 Posted September 6, 2010 Thanks chadcloman!!! I'm off to backup my database then apply your helpful instructions!! Cheers, Michael
Recommended Posts
Archived
This topic is now archived and is closed to further replies.