How do I change multiple product names all at once using an SQL Query?

[raguirre]

Hi All!

I realized I misspelled "cord" wrong on a few items in my store and want to change them all to the correct spelling at once using an SQL Query but have no idea how to write one. I have about 30 products that were added to the store and spelled "Chord" instead of "Cord". Anyone want to take a stab at it? Thanks

[tryphon]

Backup the DB and then run the following SQL statement :


update `products_description` set `products_name` = 'Cord' where `products_name` = 'Chord'

Note that the name of the table 'products description' might be prefixed in your setup.

[data_digger]

update `products_description` set `products_name` = 'Cord' where `products_name` = 'Chord'

This will only change products which are named 'Cord' EXACTLY. It won't change products like 'Cord A', 'Nice Cord' etc. It might not also change products like 'cord' if Your collation in database is set to case sensitive.

I think this is what You want (but backup Your database before executing those statements!):

UPDATE products_description
SET products_name = REPLACE(products_name,'Cord','Chord')
WHERE products_name like '%cord%'

but REPLACE is case sensitive, so You might want to execute also

UPDATE products_description
SET products_name = REPLACE(products_name,'cord','chord')
WHERE products_name like '%cord%'