Return to Question

deleted 1 characters in body; edited title

Source Link

edited Jul 19, 2012 at 17:55

Query to find and replace text inin all tables and fields of a myslqmysql db?

I need to run a query to find and replace some text in all tables of a mysql database.

I found this query, but it only looks for the text in the tbl_name table and just in the column field.

update tbl_name set column=REPLACE(column, 'fuschia', 'fuchsia');

I need it to lookslook in all tables and all fields: (everywhere in the database)

I need to run a query to find and replace some text in all tables of a mysql database.

I found this query, but it only looks for the text in the tbl_name table and just in the column field.

update tbl_name set column=REPLACE(column, 'fuschia', 'fuchsia');

I need it to looks in all tables and all fields: (everywhere in the database)

I need to run a query to find and replace some text in all tables of a mysql database.

I found this query, but it only looks for the text in the tbl_name table and just in the column field.

update tbl_name set column=REPLACE(column, 'fuschia', 'fuchsia');

I need it to look in all tables and all fields: (everywhere in the database)

Source Link

asked Jul 19, 2012 at 12:23

I need to run a query to find and replace some text in all tables of a mysql database.

I found this query, but it only looks for the text in the tbl_name table and just in the column field.

update tbl_name set column=REPLACE(column, 'fuschia', 'fuchsia');

I need it to looks in all tables and all fields: (everywhere in the database)

mysql replace