---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/regexp-like.md
cuppy_section: docs
cuppy_doc: FYBE-7B3N
cuppy_doc_uuid: e8838909-e2fc-4d51-8f41-c20946e8e6d7
cuppy_permalink: https://cuppy.io/salesforce/d/FYBE-7B3N
cuppy_version: 1
cuppy_updated: 2026-10-23T16:16:52.575Z
cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/regexp-like
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: 05d099581a09c7aced99a7a5e516353a142a77146626d5320dd9a84579da6dce
# cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks.
---

> 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](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/string-matching.html#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.

*   [Regular Expression Match Operators](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/regex-match.html)
*   [REGEXP_SUBSTR](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/regexp-substr.html)
*   [Regular Expression Syntax](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/string-matching.html#regular-expression-syntax)


---
<!-- cuppy -->
You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.
<!-- /cuppy -->