Searching like SQl "LIKE" operator

Elastic Stack Elasticsearch
1

Hello all,

Can anybody tell me how we can search in ES that "LIKE" operator work in SQl.

for EX-

{"Name":"Sumit"},
{"Name":"Sachin"}

I want to search that name which have third character is 'm' ...How we can achieve this in ES.

Thanx

Regards,
Sumit Gupta

2

"Name:m" would be equivalent to "Name LIKE "%m%". Not sure of how you can
get the "3rd character is an "m" in SQL (unless you use special regex
expressions)

-- Raffaele

On Wed, Jan 2, 2013 at 11:09 AM, Sumit Guptaa sumit.gupta.ngi@gmail.comwrote:

Hello all,

Can anybody tell me how we can search in ES that "LIKE" operator work in
SQl.

for EX-

{"Name":"Sumit"},
{"Name":"Sachin"}

I want to search that name which have third character is 'm' ...How we can
achieve this in ES.

Thanx

Regards,
Sumit Gupta

--
View this message in context:
http://elasticsearch-users.115913.n3.nabble.com/Searching-like-SQl-LIKE-operator-tp4027607.html
Sent from the Elasticsearch Users mailing list archive at Nabble.com.

--

--