SQL match function


I am looking how to perform LIKE on text type. I found a way by MATCH.

  1. Is MATCH is Elasticsearch SQL unique function or native SQL? for example: MATCH(foo, 'bar')

  2. Are there more options to perform LIKE on text type?

  3. Is there a way to use MATCH AGAINST syntax?
    [ MATCH (col1 , col2 ,...) AGAINST ( expr [ search_modifier ])]


Both MATCH and QUERY functions are ES SQL specific: Full-Text Search Functions | Elasticsearch Guide [7.16] | Elastic

LIKE only works on "exact" fields (doesn't work on text). I suggest reading the link above about the two functions, they cover a lot of scenarios and I don't think you need AGAINST.

Will Like works on text when sending the query through ODBC\JDBC?

No. JDBC/ODBC is just an interface. The query engine is the same.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.