Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MySQL Code Request


Guest

Recommended Posts

Posted

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

Posted

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.

Posted

Thanks chadcloman!!!

 

I'm off to backup my database then apply your helpful instructions!!

 

Cheers,

 

Michael

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...