regexp_replace(string, pattern, replacement)

查询

presto:default> SELECT regexp_replace('1a 2b 3c 6f', '(\d+)([abc]) ', 'aa$2 ') 
as expression;

 expression 
---------------- 
 aaa aab aac 6f 
 (1 row)

用模式替换与表达式匹配的字符串实例并替换字符串"aa"

apache_presto_sql_functions.html