son Posted January 13, 2010 Share Posted January 13, 2010 Does anyone know if it is possible to run a query to add £10 to the stored prices of all products (in column of decimal type)? If I could do this, I could save a lot of time...Son Link to comment Share on other sites More sharing options...
justsomeguy Posted January 13, 2010 Share Posted January 13, 2010 UPDATE table SET field = field + 10 Link to comment Share on other sites More sharing options...
son Posted January 13, 2010 Author Share Posted January 13, 2010 UPDATE table SET field = field + 10Many thanks, will run then:UPDATE products SET price = price + 10 WHERE active = 1That should solve my nightmare of having to change 250 items manually;-)Son Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.