global search and replace in mysql?

Question

I use the database of mysql by a certain system now.

For data structure, there is table around 10-35 in five DB each, and there is by column around 5-40 on one table more.

Well, I think whether I cannot substitute the character string that there is that there is in data of the whole these databases for a lump.

Will not there be anything, the good method?

Suggested translation

I currently use mysql as my DBMS There are 5 databases and each currently contains between 10 to 35 tables. Each table has between 5 to 40 columns.

I want to do a global replace on the whole system replacing some string with another, e.g. replace "President Bush" by "President Obama". I want to do the replace all at once. Is there any way to do this?

Answer 1

First off, to translate what I think you are saying:

I currently use mysql as my DBMS There are 5 databases and each currently contains between 10 to 35 tables. Each table has between 5 to 40 columns.

I want to do a global replace on the whole system replacing some string with another, e.g. replace "President Bush" by "President Obama". I want to do the replace all at once. Is there any way to do this?

Short answer: no.

Long(er) answer: I do not believe there is any way to do this in one easy step. You could however accomplish this in multiple steps (get the database schemas, get the table schemas, go through every column, and.... so on)