Katsuma Ito | DuckDB Snippets

Back to Code Snippets

Katsuma Ito

@ka2n-1

‌

Replace string multiple timesSQL

`replace` target string multiple time with list of replacements.

SELECT reduce([['', content], ['foo','FOO'], ['bar', 'BAR']], (x, y, i)-> ['', replace(x[2], y[1], y[2])])
FROM posts;
Copy code