2825 explained code solutions for 75 technologies


clickhouseHow to use regex in queries


SELECT * FROM tbl WHERE match(col, 'D.+')ctrl + c
tbl

table to select data from based on regex

match

match given pattern against column

col

name of the column to check regular expression on

'D.+'

regex pattern to use (find all values starting with D in our case)