# MySQL Like

**URL:** <https://discuss.elastic.co/t/mysql-like/100376>\
**Category:** Elasticsearch\
**Created:** [September 13, 2017, 3:08pm UTC](https://discuss.elastic.co/t/mysql-like/100376 "2017-09-13T15:08:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_Gartner](https://avatars.discourse-cdn.com/v4/letter/m/4da419/32.png) [@Michael\_Gartner](https://discuss.elastic.co/u/Michael_Gartner)\
**Post date:** [September 13, 2017, 3:08pm UTC](https://discuss.elastic.co/t/mysql-like/100376/1 "2017-09-13T15:08:28Z")

</div>

We would like to achieve this result

WHERE text LIKE "%quick%"  
AND text LIKE "%brown%"  
AND text LIKE "%fox%"

Example

Searching for 'fein multi master' should product the same results as 'fein multimaster'

It seems like we could achieve this with either regex or ngrams but our developers are having a hard time achieving this.

Has any had any success with something like this?

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [September 13, 2017, 3:21pm UTC](https://discuss.elastic.co/t/mysql-like/100376/2 "2017-09-13T15:21:00Z")

</div>

This is what Elasticsearch was built for. Have a look at the section around [full-text queries](https://www.elastic.co/guide/en/elasticsearch/reference/5.6/full-text-queries.html) in the documentation.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 11, 2017, 3:21pm UTC](https://discuss.elastic.co/t/mysql-like/100376/3 "2017-10-11T15:21:31Z")

</div>

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