table-wide or database-wide search and replace?
| From: | Justin French | Date: | Wed, 25 Sep 2002 03:34:21 +0000 |
| Subject: | table-wide or database-wide search and replace? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-117492@lists.php.net to get a copy of this message | ||
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