String Function REGEXP_REPLACE(x,y,z)

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select regexp_replace('new','e','o') from (values(1));

Result

+————————-+
|  EXPR$0 |
+————————-+
|   now   |
+————————-+

Here the given string new is replaced as now.