Substitute of REGEXP_LIKE(expr, pat[, match_type])

Help
1

Hi
I am looking for function equal to MySQL function [REGEXP_LIKE(expr, pat[, match_type])]
Returns 1 if the string expr matches the regular expression specified by the pattern pat , 0 otherwise. If expr or pat is NULL , the return value is NULL .

mysql> SELECT REGEXP_LIKE(‘CamelCase’, ‘CAMELCASE’);
±--------------------------------------+
| REGEXP_LIKE(‘CamelCase’, ‘CAMELCASE’) |
±--------------------------------------+
| 1 |
±--------------------------------------+

2

You can do this with RLIKE or REGEXP. If you don’t want to change your queries, write a short UDF REGEXP_LIKE that calls one of them.