REPLACE
Replaces all occurrences of a substring with another substring.
Analyze Syntax
func.replace(<str>, <old>, <new>)
Analyze Examples
func.replace('hello world', 'world', 'there')
┌───────────────┐
│ 'hello there' │
└───────────────┘
SQL Syntax
REPLACE(<str>, <old>, <new>)
SQL Examples
SELECT REPLACE('hello world', 'world', 'there');
┌─────────────┐
│ hello there │
└─────────────┘