REPLACE URI ENCODED ENTITIES WITH MYSQL - NO FUNCTION

replace-uri-encoded-entities-with-mysql-no-function.sql

SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(`field`, '%20',' '), '%22','"'), '%23','#'), '%24','$'), '%26','&'), '%27','\''), '%28','('), '%29',')'),'%2A','*'), '%2B','+'),'%2C',','),'%2D','-'),'%2E','.'),'%2F','/'),'%3A',':'),'%3B',';'),'%3C','<'),'%3D','='),'%3E','>'), '%3F','?'), '%40','@'), '%5B','['), '%5C','\\'), '%5D',']'), '%5E','^'), '%5F','_'), '%60','`'), '%7B','{'), '%7C','|'), '%7D','}'), '%7E','~'), '%80','`'), '%82','‚'), '%83','ƒ'), '%85','…'), '%91','‘'), '%92','’'), '%93','“'), '%94','”'), '%96','–'), '%97','—'), '%99','™'), '%A3','£'), '%A5','¥'), '%C0','À'), '%C1','Á'), '%C2','Â'), '%C3','Ã'), '%C4','Ä'), '%C5','Å'), '%C6','Æ'), '%C7','Ç'), '%C8','È'), '%C9','É'), '%CA',''), '%CB','Ë'), '%CC','Ì'), '%CD','Í'), '%CE','Î'), '%CF','Ï'), '%D0','Ð'), '%D1','Ñ'), '%D2','Ò'), '%D3','Ó'), '%D4','Ô'), '%D5','Õ'), '%D6','Ö'), '%D9','Ù'), '%DA','Ú'), '%DB','Û'), '%DC','Ü'), '%DF','ß'), '%E0','à'), '%E1','á'), '%E2','â'), '%E3','ã'), '%E4','ä'), '%E5','å'), '%E6','æ'), '%E7','ç'), '%E8','è'), '%E9','é'), '%EA','ê'), '%EB','ë'), '%EC','ì'), '%ED','í'), '%EE','î'), '%EF','ï'), '%F0','ð'), '%F1','ñ'), '%F2','ò'), '%F3','ó'), '%F4','ô'), '%F5','õ'), '%F6','ö'), '%F7','÷'), '%F9','ù'), '%FA','ú'), '%FB','û'), '%FC','ü'), '%FD','ý'), '%25','%');