Organizational Research By

Surprising Reserch Topic

find and replace in entire mysql database


find and replace in entire mysql database  using -'mysql'

i would like to do a find and replace inside an entire database not just a table.

How can i alter the script below to work?


  update [table_name] set [field_name] =
  replace([field_name],'[string_to_find]','[string_to_replace]');


Do i just use an asterix?


  update * set [field_name] =
  replace([field_name],'[string_to_find]','[string_to_replace]');

    

asked Sep 29, 2015 by girisha
0 votes
6 views



Related Hot Questions

6 Answers

0 votes
NULL
answered Sep 29, 2015 by ajit.chavhan
0 votes
NULL
answered Sep 29, 2015 by bhavin
0 votes
NULL
answered Sep 29, 2015 by tseetha
0 votes
NULL
answered Sep 29, 2015 by param.oncemore
0 votes
NULL
answered Sep 29, 2015 by pradip.bhoge
0 votes
NULL
answered Sep 29, 2015 by devkumargupta

...