# Conversion Like Mysql in elasticsearch

**URL:** <https://discuss.elastic.co/t/conversion-like-mysql-in-elasticsearch/33101>\
**Category:** Elasticsearch\
**Created:** [October 27, 2015, 7:08pm UTC](https://discuss.elastic.co/t/conversion-like-mysql-in-elasticsearch/33101 "2015-10-27T19:08:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Keyral](https://avatars.discourse-cdn.com/v4/letter/k/a3d4f5/32.png) [@Keyral](https://discuss.elastic.co/u/Keyral)\
**Post date:** [October 27, 2015, 7:08pm UTC](https://discuss.elastic.co/t/conversion-like-mysql-in-elasticsearch/33101/1 "2015-10-27T19:08:43Z")

</div>

Hi,  
I want conversion Like in Mysql in Elasticsearch

Exemple:  
index element [dev, developpeur, developpeuse,]

My query "v" return [dev, developpeur, developpeuse,]  
My query "de" return [dev, developpeur, developpeuse,]  
My query "deve" return [developpeur, developpeuse,]

I think at nGram, is not fonction but my works.

Thank you to your help.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [October 27, 2015, 7:37pm UTC](https://discuss.elastic.co/t/conversion-like-mysql-in-elasticsearch/33101/2 "2015-10-27T19:37:49Z")

</div>

Yes n gram is the way to go.

---

<div class="post-metadata">

**Author:** ![Keyral](https://avatars.discourse-cdn.com/v4/letter/k/a3d4f5/32.png) [@Keyral](https://discuss.elastic.co/u/Keyral)\
**Post date:** [October 27, 2015, 7:54pm UTC](https://discuss.elastic.co/t/conversion-like-mysql-in-elasticsearch/33101/3 "2015-10-27T19:54:40Z")

</div>

Hi dadoonet,

my mgram is not function

```
"ngram": {
"min_gram": "1",
"type": "edgeNGram",
"max_gram": "20" 
},

```

Where is my probleme in my elasticsearch 1.7.2.

Thank you 😉

> [@dadoonet](#):
>
> Yes n gram is the way to go.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [October 27, 2015, 8:25pm UTC](https://discuss.elastic.co/t/conversion-like-mysql-in-elasticsearch/33101/4 "2015-10-27T20:25:54Z")

</div>

It looks good.

---

<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:** [July 5, 2017, 11:42pm UTC](https://discuss.elastic.co/t/conversion-like-mysql-in-elasticsearch/33101/5 "2017-07-05T23:42:19Z")

</div>