Organizational Research By

Surprising Reserch Topic

Experts Most Trusted 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



Government Jobs Opening


...