Delete or replace a part of a string

Use the replace(referer,http_type) function to delete the value of the http_type field from the the value of the referer field. Use the replace(referer,http_type,http_method) function to replace the value of the http_type field in the value of the referer field with the value of the http_method field. The results are displayed in a table.

|
select
  replace(referer,http_type) as "Delete the value of the http_type field from the value of the referer field",
  replace(referer,http_type,http_method) as "Replace the value of the http_type field in the value of the referer field with the value of the http_method field"