I have recently taken over the running of an e-commerce website. Once in a while i will need to increase the prices of certain products by any given percenatge. The products all have a code starting with 3 letters and then digits. for instance: ffc1234, ffc1245, dcc4544, dcc5799, vff300, and so on. I may only have to update the dcc prices one month, and the ffc the next. I need to know the UPDATE query to be able to do this.
The product codes are in a column called prod_code and the prices that need to be updated are in a column called prod_prices.
I need to run an UPDATE query in PHPMYADMIN. ... can anyone help?