clickhouseHow to replace substrings
SELECT replaceAll('Thos os odeal', 'o', 'i')ctrl + creplaceAllreplaces all found substrings to new one | 'Thos os odeal'string to search and replace in |
'o'match this substring | 'i'replace to this substring |
Usage example
SELECT replaceAll('Thos os odeal', 'o', 'i')output
┌─replaceAll('Thos os odeal', 'o', 'i')─┐
│ This is ideal │
└───────────────────────────────────────┘
More of Clickhouse
- Convert datetime to unix timestamp
- Convert hex to text
- Create table example
- Add row number to results
- Select rows with certain value in array column
- Create table with UUID column
- Select where date column is between dates
- Insert array of strings in CSV format
- List all tables from all database
- String concat
See more codes...