Search working only for case sensitive data while using SQL-ES LIKE

Elastic Stack Elasticsearch
1

Hi ,

I am trying to search a Text field using SQL-ES with LIKE here is the sample code

GET /_sql
{
"query":""select * from indexname where customer LIKE  '%AR-D'"
}

here I am getting resultset only AR-D ,but i want all ar-D,AR-d....etc

2

For text fields, it's recommended you use the full-text search functions ES SQL supports: Full-Text Search Functions | Elasticsearch Guide [7.x] | Elastic

3

Hi @Andrei_Stefan ,
Thank you

here these full text search is giving me result set which contains AR as words i,e
CSV-AR,DVR-AR...etc .
But I want only records with AR-D
I am using 7.3.2 version of ES  and default analyzer
4

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