Re: table-wide or database-wide search and replace?

on 25/09/02 1:43 PM, John Holmes (holmes072000@charter.net) wrote: > It really wouldn't be that difficult, would it? it would appear not :) > Give it a database name, the program find all the names of the tables, > then loops through them all. It find all the rows for each table (maybe > limit to just text based ones, to be fancy), and makes an sql statement > to call the ereg. To really be feasible, you'd want to use the replace > and regex functions already in MySQL. Only issues you may run into is > the 30 second time limit... good point... specifically, is that a time limit imposed by mysql, php or the browser you are referring to? because i could do this on the command line (once off), and could also break the process into individual tables, or even groups of 50 rows or something if needed -- although i'd do almost anything to avoid it :) > How much will you pay me to write it?? :) I'll have a go first :P Thanks, Justin French > ---John Holmes... > >> -----Original Message----- >> From: Justin French [mailto:justin@indent.com.au] >> Sent: Tuesday, September 24, 2002 11:34 PM >> To: php >> Subject: [PHP] table-wide or database-wide search and replace? >> >> Has anyone seen or built an existing chunk of code to assist with > table- >> wide >> or database-wide search and replace in MySQL? >> >> For example a simple str_replace() style function that works on a > whole >> MySQL table would be great, database-wide would be even better, >> ereg_replace >> would be even better again, and so would the ability to specify case >> sensitivity would be better again :) >> >> I'm happy for it to be a commerical product, open source, a project or >> whatever. >> >> If it doesn't exist, does anyone want to start work on one with me? >> >> Found these notes: >> >> http://myezserver.com/downloads/mitel/howto/mysql-search-and-replace- >> howto.h >> tml >> >> So it doesn't seem too hard in theory. >> >> >> Justin French >> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >