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.