like.asciidoc 653 B

123456789101112131415161718192021222324
  1. [discrete]
  2. [[esql-like-operator]]
  3. === `LIKE`
  4. // tag::body[]
  5. Use `LIKE` to filter data based on string patterns using wildcards. `LIKE`
  6. usually acts on a field placed on the left-hand side of the operator, but it can
  7. also act on a constant (literal) expression. The right-hand side of the operator
  8. represents the pattern.
  9. The following wildcard characters are supported:
  10. * `*` matches zero or more characters.
  11. * `?` matches one character.
  12. [source.merge.styled,esql]
  13. ----
  14. include::{esql-specs}/docs.csv-spec[tag=like]
  15. ----
  16. [%header.monospaced.styled,format=dsv,separator=|]
  17. |===
  18. include::{esql-specs}/docs.csv-spec[tag=like-result]
  19. |===
  20. // end::body[]