rlike.asciidoc 448 B

123456789101112131415
  1. [discete]
  2. [[esql-rlike-operator]]
  3. ==== `RLIKE`
  4. Use `RLIKE` to filter data based on string patterns using using
  5. <<regexp-syntax,regular expressions>>. `RLIKE` usually acts on a field placed on
  6. the left-hand side of the operator, but it can also act on a constant (literal)
  7. expression. The right-hand side of the operator represents the pattern.
  8. [source,esql]
  9. ----
  10. FROM employees
  11. | WHERE first_name RLIKE ".leja.*"
  12. | KEEP first_name, last_name
  13. ----