On Thursday, November 4, 2010, Michael Southwell <michael.southw...@nyphp.com> wrote: > On 11/4/2010 08:32, p...@blu-studio.com wrote: > > I am wondering if anyone has had to search an entire database and do a > search and replace on a string. That is to search in every table, in > every row, in every field. > > > export the entire database into a file > use PHP (or a good editor) to make the replacement line by line > drop the database > re-create it by importing the modified file
This is potentially very dangerous, because you can inadvertently change column names, table names, etc. _______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
