elasticsearch-sql icon indicating copy to clipboard operation
elasticsearch-sql copied to clipboard

How search in matchQuery

Open mhsankar opened this issue 5 years ago • 4 comments

Hi How can search exactly word in elasticsearch in matchQuery? for example how can search Text=matchQuery('"Book A" sales') ? it mean i want to search every document maybe has sales or exactly Book A or both? when i search some document has Book some has A some has sales. i dont want it.

mhsankar avatar Aug 13 '19 03:08 mhsankar

please help me

mhsankar avatar Aug 21 '19 13:08 mhsankar

select * from myindex where q=query(query='"Book A" sales', default_field='Text')

shi-yuan avatar Aug 25 '19 03:08 shi-yuan

Thanks but i want to use matchQuery because i want to search with TF/IDF algorithm. can you help me in matchQuery ?

mhsankar avatar Aug 25 '19 12:08 mhsankar

select * from myindex where Text=matchQuery(query='"Book A" sales')

shi-yuan avatar Sep 08 '19 12:09 shi-yuan