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

[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.