In MySQL, how to change all columns names of all tables to remove the string "\_euro" from columns names?

I just could find a way to search tables having some columns containing "\_euro" in their names:

```
SELECT DISTINCT TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE "%_euro"
    AND TABLE_SCHEMA='my_database'

```

For example, for the column named `price_total_euro` I want to rename it as `price_total`