-- position:显示hello在字符串第一个出现的位置。
select position('ckhelloworldhellospark','hellow') AS positionSearch;
-- match:匹配到了则返回1,否则返回0
select match('ckhelloworldhellospark','hello') AS matchSearch;
标签:ckhelloworldhellospark,--,正则,clickhouse,字符串,position,match,select From: https://www.cnblogs.com/thxj/p/16947500.html