Skip to main content

REPLACE

Returns a string formed by substituting a portion of a string for every occurrence of another string.

See also:
[SELECT]


Syntax

SELECT REPLACE(character_expression, pattern, replacement) FROM <multipartIdentifier>;

Arguments

character_expression
A literal string or string column that you want to perform the replacement on.

pattern
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.

replacement
The replacement string.

If replacement is not initially a string, it is cast to a UTF-8 string prior to processing.

The BINARY collating sequence is used for comparisons.

Return Value(s)

Returns a string.


Examples

Replace a string pattern in a column

SELECT replace(name, 'prd', 'production') AS replacement_string
FROM google.compute.instances
WHERE project = 'stackql-demo'
AND zone = 'australia-southeast1-a';

For more information, see https://www.sqlite.org/lang_corefunc.html#replace