Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

quick and easy way to modify


billybrag

Recommended Posts

Posted

is there an sql query that i can run that will update all of my models field to change it from

a four digit numbe like it is now, ie

 

1234

 

 

to

 

M1234

 

all of the fields will be preceeded by M

 

thanks in advance

 

:)

"because it'll hurt more"- the greatest film of all time?

Posted

UPDATE products_description SET products_model = CONCAT('M', products_model)

 

Should do it. Assuming you are wanting to change "products model" field of "products description" table.

Archived

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

×
×
  • Create New...