How to remove the extra word in the product name?

Question

MySQL

There is a product name, for example:
Sofa Model "Sun".
So you need to remove the word "Sofa" in the database only in the name of the product. Positions 1300, hands very long. Is there a MySQL console command for WooCommerce or a plugin?
Who will tell?

Answer 1

The poor sofa will be mercilessly deleted in the product field in the table_name table
UPDATE table_name SET product = REPLACE(product, 'Sofa', '')

Answer 2

update + replace https://dev.mysql.com/doc/refman/8.0/en/string-fun...