# Wildcard + phrase combination search case insensitive

**URL:** <https://discuss.elastic.co/t/wildcard-phrase-combination-search-case-insensitive/154463>\
**Category:** Elasticsearch\
**Created:** [October 29, 2018, 3:52pm UTC](https://discuss.elastic.co/t/wildcard-phrase-combination-search-case-insensitive/154463 "2018-10-29T15:52:01Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [October 30, 2018, 8:21am UTC](https://discuss.elastic.co/t/wildcard-phrase-combination-search-case-insensitive/154463/2 "2018-10-30T08:21:11Z")

</div>

Hi @viphuangwei,  
The `query` special function in SQL is a wrapper for a `query_string` query from Elasticsearch. If you try the `translate` API from SQL you will see the actual query that ES is using to return the results.

These being said, `query_string` and phrase matching with wildcard will not work, thus the results you see. See [here](https://discuss.elastic.co/t/wildcard-with-exact-phrase-search-using-query-string/102631/5) a suggestion from of the Lucene/ES developers about the type of query to use for such functionality. Unfortunately, ES SQL doesn't use that.

---

_[View the full topic](https://discuss.elastic.co/t/wildcard-phrase-combination-search-case-insensitive/154463)._