Replace all occurrences in a database

replace-sql-database

SELECT 
    concat('UPDATE ',
            my_table_name,
            ' SET ',
            my_column_name,
            ' = REPLACE(',
            my_column_name,
            ', \'my_old_str\', \'my_new_str\')',
			' WHERE ',
			my_column_name,
			' LIKE \'%my_old_str%\';')
FROM
    INFORMATION_SCHEMA.COLUMNS c
WHERE
    TABLE_SCHEMA = 'my_database'
        AND DATA_TYPE IN ('char' , 'varchar')