How to replace multiple product option titles at once?

Titles of product options are stored in the title column of the catalog_product_option_title table:

It a simple case, you can adjust multiple titles at once using the MySQL REPLACE statement, e.g.:

UPDATE catalog_product_option_title SET title = REPLACE(title, '...', '...');

In a complex case, you can dump the catalog_product_option_title table using mysqldump, then adjust titles using a text manipulation tool like sed, and then import the catalog_product_option_title table back to the database.