Guest Posted February 25, 2004 Share Posted February 25, 2004 How would I put together an SQL query that would change ALL prices on the store which are currently ?10 to ?9 for example? Link to comment Share on other sites More sharing options...
Nick Weisser Posted February 25, 2004 Share Posted February 25, 2004 I didn't try that so better make sure to backup your products table before you execute my suggested query: UPDATE TABLE_PRODUCTS SET products_price = 9 WHERE products_price = 10; If you do this from phpMyAdmin or MySQL command line, you should replace TABLE_PRODUCTS by the actual table name. Default is 'products'. Cheers, Nick Link to comment Share on other sites More sharing options...
Guest Posted February 25, 2004 Share Posted February 25, 2004 Thanks :) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.