# About syntax of the regexp\_like function

**URL:** <https://community.dremio.com/t/about-syntax-of-the-regexp-like-function/97>\
**Category:** Uncategorized\
**Created:** [July 21, 2017, 5:35pm UTC](https://community.dremio.com/t/about-syntax-of-the-regexp-like-function/97 "2017-07-21T17:35:28Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dmitry\_R](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/dmitry_r/32/322_2.png) [@Dmitry\_R](https://community.dremio.com/u/Dmitry_R)\
**Post date:** [July 21, 2017, 5:35pm UTC](https://community.dremio.com/t/about-syntax-of-the-regexp-like-function/97/1 "2017-07-21T17:35:28Z")

</div>

Hi there,  
Could you please answer me, should this SQL function return true: regexp\_like (‘us’,‘u’) ? I’m trying to use regex for my task, but I’m really stuck with the simple thing.

---

<div class="post-metadata">

**Author:** ![venki](https://avatars.discourse-cdn.com/v4/letter/v/f0a364/32.png) [@venki](https://community.dremio.com/u/venki)\
**Post date:** [July 21, 2017, 5:40pm UTC](https://community.dremio.com/t/about-syntax-of-the-regexp-like-function/97/2 "2017-07-21T17:40:22Z")

</div>

regexp\_like(‘us’, ‘u’) returns false as the Java regexp here is ‘u’ which doesn’t match the input string ‘us’. You may want to give the regex as ‘.\*u.\*’

---

<div class="post-metadata">

**Author:** ![Dmitry\_R](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/dmitry_r/32/322_2.png) [@Dmitry\_R](https://community.dremio.com/u/Dmitry_R)\
**Post date:** [July 24, 2017, 5:36am UTC](https://community.dremio.com/t/about-syntax-of-the-regexp-like-function/97/3 "2017-07-24T05:36:07Z")

</div>

Could you please explain the difference between REGEXP\_MATCHES and REGEXP\_LIKE functions?

---

<div class="post-metadata">

**Author:** ![chris](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/chris/32/19_2.png) [@chris](https://community.dremio.com/u/chris)\
**Post date:** [July 24, 2017, 3:37pm UTC](https://community.dremio.com/t/about-syntax-of-the-regexp-like-function/97/4 "2017-07-24T15:37:22Z")

</div>

Hi Dmitry,

REGEXP\_MATCHES and REGEXP\_LIKE are actually the same function within Dremio. For convenience both are defined; they are PostgreSQL and Oracle syntax (respectively).

~Chris

---

<div class="post-metadata">

**Author:** ![dfleckinger](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/dfleckinger/32/370_2.png) [@dfleckinger](https://community.dremio.com/u/dfleckinger)\
**Post date:** [October 29, 2019, 4:20pm UTC](https://community.dremio.com/t/about-syntax-of-the-regexp-like-function/97/5 "2019-10-29T16:20:07Z")

</div>

hi, it appears regexp\_like and regexp\_matches are both case sensitive and do not accept additional parameters such as the ‘i’ (case insensitive parameter) for Oracle.

To make the regexp case insensitive, you could add (?i) at the beginning of the regexp