How can I write a query using ElasticSearch similar to SQL "Like" Operator?

Question

I want to convert following query to an Elasticsearch query.

Select * from Books where title like '%net%'

see http://stackoverflow.com/questions/31173988/emulate-a-sql-like-search-with-elasticsearch — Aydin K., Jun 16 '16 at 08:26
Similar question: https://stackoverflow.com/questions/44791075/in-elasticsearch-how-do-i-search-for-an-arbitrary-substring — Patrick Szalapski, Jun 28 '17 at 02:33

score 1 · Answer 1 · answered Oct 14 '15 at 07:42

1

POST <index>/<type>/_search
{
    "query": {
        "regexp": {
            "title": ".*net.*"
        }
    }
}

answered Oct 14 '15 at 07:42

bittusarkar

this gives an error... is there any way to do this using "match" – BonieZat Oct 14 '15 at 09:16
Can you please give more information about the error? – bittusarkar Oct 14 '15 at 09:20

1 Answers1