# QueryString Match "x and y" exact phrase ("and" being literal, not "&&") **URL:** \ **Category:** Elasticsearch\ **Created:** [April 15, 2013, 5:32pm UTC](https://discuss.elastic.co/t/querystring-match-x-and-y-exact-phrase-and-being-literal-not/11592 "2013-04-15T17:32:32Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Evan\_Roberts](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/evan_roberts/32/2385_2.png) [@Evan\_Roberts](https://discuss.elastic.co/u/Evan_Roberts)\ **Post date:** [April 15, 2013, 5:32pm UTC](https://discuss.elastic.co/t/querystring-match-x-and-y-exact-phrase-and-being-literal-not/11592/1 "2013-04-15T17:32:32Z")
I can't seem to get QueryString to match a string, eg: "abbot and costello" The MySQL equivalent would be WHERE field LIKE '%abbot and costello%' I believe this is a fairly straightforward question, but in any case here's a link to the post I made on StackOverflow with some example code (Elastica): > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\ **Post date:** [April 16, 2013, 6:02pm UTC](https://discuss.elastic.co/t/querystring-match-x-and-y-exact-phrase-and-being-literal-not/11592/2 "2013-04-16T18:02:18Z")
It's "Abbot_t_ and Costello". On Monday, April 15, 2013 1:32:32 PM UTC-4, Evan Roberts wrote: > I can't seem to get QueryString to match a string, eg: "abbot and costello" > > The MySQL equivalent would be > > WHERE field LIKE '%abbot and costello%' > > I believe this is a fairly straightforward question, but in any case > here's a link to the post I made on StackOverflow with some example code > (Elastica): > > [stop words - ElasticSearch/Elastica: searching for exact term that includes "and" or other stopwords - Stack Overflow](http://stackoverflow.com/questions/16007315/elasticsearch-elastica-searching-for-exact-term-that-includes-and-or-other-st) -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Evan\_Roberts](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/evan_roberts/32/2385_2.png) [@Evan\_Roberts](https://discuss.elastic.co/u/Evan_Roberts)\ **Post date:** [April 17, 2013, 3:54am UTC](https://discuss.elastic.co/t/querystring-match-x-and-y-exact-phrase-and-being-literal-not/11592/3 "2013-04-17T03:54:21Z")
This was it, in any case thanks for taking the time to point out the typo 🙂 On Tue, Apr 16, 2013 at 12:02 PM, Igor Motov [imotov@gmail.com](mailto:imotov@gmail.com) wrote: > It's "Abbot_t_ and Costello". > > On Monday, April 15, 2013 1:32:32 PM UTC-4, Evan Roberts wrote: > > > I can't seem to get QueryString to match a string, eg: "abbot and > > costello" > > > > The MySQL equivalent would be > > > > WHERE field LIKE '%abbot and costello%' > > > > I believe this is a fairly straightforward question, but in any case > > here's a link to the post I made on StackOverflow with some example code > > (Elastica): > > [http://stackoverflow.com/\*\*questions/16007315/\*\*elasticsearch-elastica-](http://stackoverflow.com/ **questions/16007315/** elasticsearch-elastica-)\*\* > > searching-for-exact-term-that-\*\*includes-and-or-other-st[http://stackoverflow.com/questions/16007315/elasticsearch-elastica-searching-for-exact-term-that-includes-and-or-other-st](http://stackoverflow.com/questions/16007315/elasticsearch-elastica-searching-for-exact-term-that-includes-and-or-other-st) > > -- > You received this message because you are subscribed to a topic in the > Google Groups "elasticsearch" group. > To unsubscribe from this topic, visit > [https://groups.google.com/d/topic/elasticsearch/BsOM7Bpo\_Ts/unsubscribe?hl=en-US](https://groups.google.com/d/topic/elasticsearch/BsOM7Bpo_Ts/unsubscribe?hl=en-US) > . > To unsubscribe from this group and all its topics, send an email to > [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- Evan Roberts -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 2:40am UTC](https://discuss.elastic.co/t/querystring-match-x-and-y-exact-phrase-and-being-literal-not/11592/4 "2017-07-06T02:40:51Z")