like.asciidoc 688 B

1234567891011121314151617181920212223242526
  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. include::./types/like.asciidoc[]
  13. [source.merge.styled,esql]
  14. ----
  15. include::{esql-specs}/docs.csv-spec[tag=like]
  16. ----
  17. [%header.monospaced.styled,format=dsv,separator=|]
  18. |===
  19. include::{esql-specs}/docs.csv-spec[tag=like-result]
  20. |===
  21. // end::body[]