Hi, I could write a quick script to fix the following, but just out of curiosity, if there's a quicker way to do it from the mysql command line, that'd be cool to know.
I've got a few thousand rows of data that have URI escaped characters in them, and I've fixed the code that was doing it, but now I need to cleanup the data. Is there a quick and dirty way to update such that I can only affect the portion of a string (varchar column) that matches a regexp? (e.g. replace all '%20' with ' ' leaving the rest untouched?) Yani -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]