SELECT td_url,
  -- 'http(s)://' を除外 --
  regexp_replace(td_url,'http(.)*://','') AS replace1,
  --'?'以降のパラメータを除外 --
  regexp_replace(td_url,'\?(.)*','') AS replace2,
  -- レコードの末尾の '/' を除外 --
  regexp_replace(td_url,'/$','') AS replace3,
  -- 'http(s)://' を除外 | '?'以降のパラメータを除外 | レコードの末尾の '/' を除外 --
  regexp_replace(td_url,'http(.)*://|\?(.)*|/$','') AS replace4
FROM access_log
LIMIT 10