`REGEXP_LIKE`
Data 360 Query Guide, mirrored from developer.salesforce.com: **Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API
markdownreferencev1FYBE-7B3Nguide: data-cloud-query-guidestage: referencetrust: officialsource: developer.salesforce.comservice: data360interface: sql`REGEXP_LIKE`Data 360Data CloudData 360 Query Guide
Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/regexp-like.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.
REGEXP_LIKE
Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API
Returns true if the string matches the regular expression pattern.
<string>: The string to match against.<pattern>: The regular expression pattern.
flags: A string of option flags that modify matching behavior. Flags can be combined (for example,'iq').
| Flag | Description |
|---|---|
i | Case-insensitive matching |
c | Case-sensitive matching (default) |
q | Literal-string matching (disables regex metacharacters) |
Returns a boolean value indicating whether the string matches the pattern.
- Equivalent to the
~operator but in function form. - Matches anywhere within the string by default. Use
^and$anchors for full string matching. - Newline-sensitivity flags (
n,m,s,p,w) aren’t supported. - For detailed regex syntax, see Regular Expression Syntax.
Check whether a string matches a pattern.
Returns true.
Check whether a string contains digits.
Returns true.
Match the entire string using anchors.
Returns true.
Returns false because the entire string does not match.
Use the i flag for case-insensitive matching.
Returns true.
Use the q flag to treat the pattern as a literal string, disabling regex metacharacters.
Returns true, matching the literal characters a.b rather than “any character between a and b.”
Returns false.
Use in a WHERE clause to filter data.
Returns rows with valid email format.