Returns a string formed by substituting a portion of a string for every occurrence of another string.
SELECT REPLACE(character_expression, pattern, replacement) FROM <multipartIdentifier>;
A literal string or string column that you want to perform the replacement on.
The substring to be found in the original string.
If pattern is an empty string or is not found in character_expression, then character_expression will be returned unchanged.
The replacement string.
If replacement is not initially a string, it is cast to a UTF-8 string prior to processing.
BINARYcollating sequence is used for comparisons.
Returns a string.
Replace a string pattern in a column
SELECT replace(name, 'prd', 'production') AS replacement_string
WHERE project = 'stackql-demo'
AND zone = 'australia-southeast1-a';
For more information, see https://www.sqlite.org/lang_corefunc.html#replace