-- https://www.google.co.jp/search?num=50&safe=off&q=トレジャー データ （タブ有り）のエンコード・デコード --
SELECT
  URL_ENCODE('https://www.google.co.jp/search?num=50&safe=off&q=トレジャー  データ') AS encoded,
  TD_URL_DECODE('https%3A%2F%2Fwww.google.co.jp%2Fsearch%3Fnum%3D50%26safe%3Doff%26q%3D%E3%83%88%E3%83%AC%E3%82%B8%E3%83%A3%E3%83%BC++%E3%83%87%E3%83%BC%E3%82%BF') AS td_decoded,
  URL_DECODE(   'https%3A%2F%2Fwww.google.co.jp%2Fsearch%3Fnum%3D50%26safe%3Doff%26q%3D%E3%83%88%E3%83%AC%E3%82%B8%E3%83%A3%E3%83%BC++%E3%83%87%E3%83%BC%E3%82%BF') AS decoded
FROM access_log
LIMIT 1