# Using sql server queries in elasticsearch 5.6.3

**URL:** <https://discuss.elastic.co/t/using-sql-server-queries-in-elasticsearch-5-6-3/104027>\
**Category:** Logstash\
**Created:** [October 15, 2017, 3:23pm UTC](https://discuss.elastic.co/t/using-sql-server-queries-in-elasticsearch-5-6-3/104027 "2017-10-15T15:23:30Z")\
**Posts on this page:** 5\
**Page:** 3

<div class="post-metadata">

**Author:** ![parsa](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/parsa/32/23227_2.png) [@parsa](https://discuss.elastic.co/u/parsa)\
**Post date:** [November 13, 2017, 6:11pm UTC](https://discuss.elastic.co/t/using-sql-server-queries-in-elasticsearch-5-6-3/104027/41 "2017-11-13T18:11:44Z")

</div>

How can I use **LIKE** condition in calling search url?  
using LIKE condition is diffrent and seperate from **autocomplete option**?  
I used this:  
[http://localhost:9200/\_search?q=servername:"\*name\*"+OR+action:"\*convert\*"](http://localhost:9200/_search?q=servername:%22*name*%22+OR+action:%22*convert*%22)  
but it results wrong

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [November 13, 2017, 8:45pm UTC](https://discuss.elastic.co/t/using-sql-server-queries-in-elasticsearch-5-6-3/104027/42 "2017-11-13T20:45:10Z")

</div>

Please ask Elasticsearch questions in the Elasticsearch category.

---

<div class="post-metadata">

**Author:** ![parsa](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/parsa/32/23227_2.png) [@parsa](https://discuss.elastic.co/u/parsa)\
**Post date:** [December 9, 2017, 10:45am UTC](https://discuss.elastic.co/t/using-sql-server-queries-in-elasticsearch-5-6-3/104027/43 "2017-12-09T10:45:17Z")

</div>

How can I set **"Subject"** and **"Decription"** columns on an index with having **CompletionField** property for using suggestion on search,  
For implement a complete search structure what I needed? and how can I make the structure for that (mean defining index and type...)?  
My this question is related to this topic?

---

<div class="post-metadata">

**Author:** ![parsa](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/parsa/32/23227_2.png) [@parsa](https://discuss.elastic.co/u/parsa)\
**Post date:** [December 13, 2017, 3:03pm UTC](https://discuss.elastic.co/t/using-sql-server-queries-in-elasticsearch-5-6-3/104027/44 "2017-12-13T15:03:23Z")

</div>

Is there any recommendation?

---

<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:** [January 10, 2018, 3:03pm UTC](https://discuss.elastic.co/t/using-sql-server-queries-in-elasticsearch-5-6-3/104027/45 "2018-01-10T15:03:26Z")

</div>

Closed on January 10, 2018, 3:03pm UTC

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

[Previous page](https://discuss.elastic.co/t/using-sql-server-queries-in-elasticsearch-5-6-3/104027.md?page=2)