on 25/09/02 1:43 PM, John Holmes ([EMAIL PROTECTED]) 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
> ---John Holmes...
>> -----Original Message-----
>> From: Justin French [mailto:[EMAIL PROTECTED]]
>> 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
>> or database-wide search and replace in MySQL?
>> For example a simple str_replace() style function that works on a
>> MySQL table would be great, database-wide would be even better,
>> 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
>> If it doesn't exist, does anyone want to start work on one with me?
>> Found these notes:
>> 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
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php