How to expand using of trim() and replace() for multiple tables and columns

Question

I have 20 table that each of the tables has 20 columns. The type of the all columns are varchar. I want to use replace() and trim() in MySQL. Something like this:

UPDATE table1 SET col1 = TRIM(REPLACE(`col1`, 'x', 'y' ));

Now I'm looking for a way to do that as generalized. In fact I can't use of the above query for all tables and columns (20*20=400 times). Is it possible to I expand above query for all tables and columns ?

In other word, How can I use * for select all columns into trim() or replace() ?

Answer 1

Here's a start. MySQL isn't my specialty but the general idea should work.

select
    concat(
        'update ', table_name, ' set ',
        group_concat(
            concat( column_name, ' = trim(replace(', column_name, ', ''x'', ''y''))' )
        )
    )
from information_schema.columns
group by table_name