MySQL Encoded URI Search and Replace
So I can definitely not take credit for this trick. The credit goes to Augusto Bott of the Pythian Group for this. I have a table in my DB that has columns of encoded URIs. The list of URI encoding character translations is available here. To accomplish this, the MySQL REPLACE function was used. 1234567891011121314151617181920212223mysql> …
By eric