MySQL Replace characters in every table and column of a database

Question

Hello

I'd like to replace a string in every column and every table of a specific database. Is there a way to do this ?

Thanks in advance :)

Edit: That is because I have spotted Gibberish at some locations and it will take me days to fix it one by one

Answer 1

Not without doing some programming.
The most simple approach would be to use show/describe commands in your favorite language and run on the result set (names of columns/tables) and create from that a list of UPDATE queries to run on your DB.

Why don't you write it and Open Source it, you are not the first to look for something like that (Or google it, there might be a script ready somewhere).