# Chapter 7: create Search term query

**URL:** <https://forums.kodeco.com/t/chapter-7-create-search-term-query/41596>\
**Category:** Server Side Swift with Vapor\
**Created:** [April 15, 2018, 8:12pm UTC](https://forums.kodeco.com/t/chapter-7-create-search-term-query/41596 "2018-04-15T20:12:13Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![yoyohu](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/yoyohu/32/102075_2.png) [@yoyohu](https://forums.kodeco.com/u/yoyohu)\
**Post date:** [April 15, 2018, 8:12pm UTC](https://forums.kodeco.com/t/chapter-7-create-search-term-query/41596/1 "2018-04-15T20:12:13Z")

</div>

How can I create a ‘contains’ query? And add this to the group query?  
so you can search for ‘my’ or ‘god’ instead of Oh+My+God

---

<div class="post-metadata">

**Author:** ![0xtim](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/0xtim/32/111111_2.png) [@0xtim](https://forums.kodeco.com/u/0xtim)\
**Post date:** [April 15, 2018, 8:58pm UTC](https://forums.kodeco.com/t/chapter-7-create-search-term-query/41596/2 "2018-04-15T20:58:25Z")

</div>

@yoyohu `import FluentSQL` and then you should be able to do

```swift
try or.filter(\Acronym.long ~~ searchTerm)

```

---

<div class="post-metadata">

**Author:** ![yoyohu](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/yoyohu/32/102075_2.png) [@yoyohu](https://forums.kodeco.com/u/yoyohu)\
**Post date:** [April 15, 2018, 9:12pm UTC](https://forums.kodeco.com/t/chapter-7-create-search-term-query/41596/3 "2018-04-15T21:12:19Z")

</div>

> [@0xtim](#):
>
> try or.filter(\Acronym.long ~~ searchTerm)

Correct!  
thanks!  
Where do I find this in the docs?  
i have missed this operator at:  
[https://docs.vapor.codes/2.0/fluent/query/](https://docs.vapor.codes/2.0/fluent/query/)

---

<div class="post-metadata">

**Author:** ![yoyohu](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/yoyohu/32/102075_2.png) [@yoyohu](https://forums.kodeco.com/u/yoyohu)\
**Post date:** [April 15, 2018, 9:14pm UTC](https://forums.kodeco.com/t/chapter-7-create-search-term-query/41596/4 "2018-04-15T21:14:08Z")

</div>

my bad:  
I see now…  
coming soon 😉  
[https://docs.vapor.codes/3.0/fluent/query-builder/](https://docs.vapor.codes/3.0/fluent/query-builder/)

---

<div class="post-metadata">

**Author:** ![0xtim](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/0xtim/32/111111_2.png) [@0xtim](https://forums.kodeco.com/u/0xtim)\
**Post date:** [June 21, 2018, 11:11am UTC](https://forums.kodeco.com/t/chapter-7-create-search-term-query/41596/5 "2018-06-21T11:11:54Z")

</div>

Yep will be coming with the release! But the source and tests are the best place

---

<div class="post-metadata">

**Author:** ![pyae](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/pyae/32/81494_2.png) [@pyae](https://forums.kodeco.com/u/pyae)\
**Post date:** [December 4, 2018, 8:46am UTC](https://forums.kodeco.com/t/chapter-7-create-search-term-query/41596/6 "2018-12-04T08:46:11Z")

</div>

“~” operator not working now. How do you do now?

---

<div class="post-metadata">

**Author:** ![shogunkaramazov](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/shogunkaramazov/32/108826_2.png) [@shogunkaramazov](https://forums.kodeco.com/u/shogunkaramazov)\
**Post date:** [December 4, 2018, 9:06am UTC](https://forums.kodeco.com/t/chapter-7-create-search-term-query/41596/7 "2018-12-04T09:06:48Z")

</div>

@0xtim Can you please help with this when you get a chance? Thank you - much appreciated! :]

---

<div class="post-metadata">

**Author:** ![pyae](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/pyae/32/81494_2.png) [@pyae](https://forums.kodeco.com/u/pyae)\
**Post date:** [December 4, 2018, 9:27am UTC](https://forums.kodeco.com/t/chapter-7-create-search-term-query/41596/8 "2018-12-04T09:27:35Z")

</div>

It can be solved with “~=”. Hope this can help someone someday

---

<div class="post-metadata">

**Author:** ![shogunkaramazov](https://assets.chunter.kodeco.com/user_avatar/forums.kodeco.com/shogunkaramazov/32/108826_2.png) [@shogunkaramazov](https://forums.kodeco.com/u/shogunkaramazov)\
**Post date:** [December 4, 2018, 9:31am UTC](https://forums.kodeco.com/t/chapter-7-create-search-term-query/41596/9 "2018-12-04T09:31:42Z")

</div>

@pyae Thank you for sharing the solution - much appreciated! :]