>Phil: could you create such a stored procedure that would allow regexp >like replaces in update queries? I've googled-in-vain for solutions to >that problem. And having never written a stored procedure, that's way >beyond my weak SQL fu. I believe it is possible to create a regexp matching SQL function in MySQL. I've never tried it, but I believe that there is a support library that adds some additional functions to do this (and more). google for PREG_REPLACE.
I've always shied away from DB replacements like that. Ive always thought that it's better to do that sort of update through business logic in the application, not in the DB. _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
