Change Product Model Numbers en masse?

[Kevin205]

What is the best way to mass replace existing products_models without changing products_ids; for a given manufctuer?

By mistake products_models are entered as numeric. Leaving out the manufacturers abbreviation, in-front of the model number.

Need to change from 123456 to GHD-123456.

What is the best way to do this, other than one by one through PHPMyAdmin?

[allthingsidLeroy]

Back up your database first because bad things happen accidentally.

UPDATE products SET products_model = CONCAT("GHD-",products_model);

This will update every product to have its model number prepended with "GHD-".

[Kevin205]

Thank you for the reply.

How would you limit this concatenation to a specific manufacturers_id from zen_manufacturers table?

[allthingsidLeroy]

Let's say the manufacturer_id you wanted to work with was 1. Here's what the query would look like:

UPDATE products SET products_model = CONCAT("GHD-",products_model) WHERE manufacturers_id = 1;

If you wanted to do this by name, you could, but it would require some joins.

[g2ktcf]

Let's say the manufacturer_id you wanted to work with was 1. Here's what the query would look like:

UPDATE products SET products_model = CONCAT("GHD-",products_model) WHERE manufacturers_id = 1;

If you wanted to do this by name, you could, but it would require some joins.

If this is for a small number of manufacturers I would use the above as its simple and clean. However, if you are not familiar with SQL statements for modifying the database...be very careful...in fact..if that is the case, post what you want to change and let one of the experts give you the SQL statement to run as a mistake could be costly...BACKUP....BACKUP....BACKUP lol.

[Kevin205]

If this is for a small number of manufacturers I would use the above as its simple and clean. However, if you are not familiar with SQL statements for modifying the database...be very careful...in fact..if that is the case, post what you want to change and let one of the experts give you the SQL statement to run as a mistake could be costly...BACKUP....BACKUP....BACKUP lol.

Thank you for the advice. Don't know much about SQL statements.

My case is exactly as I stated.

I need to change / revise existing products_models without changing products_ids; for a defined manufacturer in the cart.

ie. Need to change products_models from 123456 to GHD-123456, for XYZ manufacturer (XYZ manufacturers_id is 5)

What is the SQL statement for the above?
Is it not the following:

UPDATE products SET products_model = CONCAT("GHD-",products_model) WHERE manufacturers_id = 5;