like.asciidoc 525 B

1234567891011121314151617181920
  1. [discrete]
  2. [[esql-like-operator]]
  3. === `LIKE`
  4. Use `LIKE` to filter data based on string patterns using wildcards. `LIKE`
  5. usually acts on a field placed on the left-hand side of the operator, but it can
  6. also act on a constant (literal) expression. The right-hand side of the operator
  7. represents the pattern.
  8. The following wildcard characters are supported:
  9. * `*` matches zero or more characters.
  10. * `?` matches one character.
  11. [source,esql]
  12. ----
  13. FROM employees
  14. | WHERE first_name LIKE "?b*"
  15. | KEEP first_name, last_name
  16. ----