# Filter a cell containing two different words (not side by side) \[Jun 21\] **URL:** \ **Category:** Discord-Discussions\ **Created:** [November 3, 2022, 10:12am UTC](https://community.nocodb.com/t/filter-a-cell-containing-two-different-words-not-side-by-side-jun-21/561 "2022-11-03T10:12:36Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:12am UTC](https://community.nocodb.com/t/filter-a-cell-containing-two-different-words-not-side-by-side-jun-21/561/1 "2022-11-03T10:12:36Z")
> 🙋‍♂️ **vibrantium** _asked_ ## Hello 👋 I’m a beginner in both spreadsheet & database & I want to clarify something when using the API: when I want to find a cell containing two different words (that are not side-to-side), what operators should I use? Do I have to use eq combined with and? ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:12am UTC](https://community.nocodb.com/t/filter-a-cell-containing-two-different-words-not-side-by-side-jun-21/561/2 "2022-11-03T10:12:37Z")
> 👨‍🦲 **dstala** _replied_ #### One way I could think of is by using 2x `like` with an `and` in between. #### #### You will have to replicate the same over API ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/aa8d8e33e2eb4913f4e0fbd8aefb85d82ee4c89f.png) # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:12am UTC](https://community.nocodb.com/t/filter-a-cell-containing-two-different-words-not-side-by-side-jun-21/561/3 "2022-11-03T10:12:38Z")
> 🙋‍♂️ **vibrantium** _replied_ #### Thank you kindly!! I will try it, does the “Like” operator pick up words that include our search word? Say, if one of the words in the cell said “Amazonian” & we still search for “Amazon” will that cell still get picked up? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:12am UTC](https://community.nocodb.com/t/filter-a-cell-containing-two-different-words-not-side-by-side-jun-21/561/4 "2022-11-03T10:12:39Z")
> 👨‍🦲 **dstala** _replied_ #### yes # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:12am UTC](https://community.nocodb.com/t/filter-a-cell-containing-two-different-words-not-side-by-side-jun-21/561/5 "2022-11-03T10:12:40Z")
> 🙋‍♂️ **vibrantium** _replied_ #### thank you for your help! I think a feature I’d like to request is to find a way so that if i use the “like” operator whenever I filter things, it picks up whole words instead of elements/parts of words? Like my example earlier, if I want to search “Amazon” in a cell full of other words but one cell spells it as “Amazonian” instead, that one cell shouldn’t be selected? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:12am UTC](https://community.nocodb.com/t/filter-a-cell-containing-two-different-words-not-side-by-side-jun-21/561/6 "2022-11-03T10:12:41Z")
> 👨‍🦲 **dstala** _replied_ #### You can search for Amazon with a space suffix :: "Amazon " # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:12am UTC](https://community.nocodb.com/t/filter-a-cell-containing-two-different-words-not-side-by-side-jun-21/561/7 "2022-11-03T10:12:42Z")
> 🙋‍♂️ **vibrantium** _replied_ #### oh okay that’s good news!! # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:12am UTC](https://community.nocodb.com/t/filter-a-cell-containing-two-different-words-not-side-by-side-jun-21/561/8 "2022-11-03T10:12:43Z")
> 🙋‍♂️ **vibrantium** _replied_ #### Hello! I am back with a similar question (thus I feel hesitant to create a new thread): if I want to search a sentence (so a string containing spaces) in my table using the axios request, do I have to use the “” quotation mark at both ends of my strings? #### #### I’m trying to list the rows in my table but i want that list to not include several rows who have a particular column-cell combination. #### #### This is how the params looks like when I console log it: #### #### ```js #### where=(ID,lt,18)~and(Name,not,Marigold Company)~and(Name,not,Forager’s Daughter Company)~and(Name,not,Pacific Northwest Company)``` #### #### That gets put in: `params: {where: params}` #### #### I also have tried encodeURI but my table list still includes those Name i want to exclude # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:12am UTC](https://community.nocodb.com/t/filter-a-cell-containing-two-different-words-not-side-by-side-jun-21/561/9 "2022-11-03T10:12:44Z")
> 🙋‍♂️ **vibrantium** _replied_ #### Okay i have tried using escape() too so the tick mark in “Forager’s Daughter Company” became encoded but it still shows all the rows whose ID are below 18 # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:12am UTC](https://community.nocodb.com/t/filter-a-cell-containing-two-different-words-not-side-by-side-jun-21/561/10 "2022-11-03T10:12:46Z")
> 🙋‍♂️ **vibrantium** _replied_ #### okay nevermind it’s solved! I just scrolled at the very bottom of this & just saw that for “not” it is formatted a little differently [REST APIs](https://docs.nocodb.com/developer-resources/rest-apis#comparison-operators) # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 10:12am UTC](https://community.nocodb.com/t/filter-a-cell-containing-two-different-words-not-side-by-side-jun-21/561/11 "2022-11-03T10:12:47Z")
[Autogenerated from discord](https://discord.com/channels/661905455894888490/983184575306039306) * * * #### Join [NocoDB’s](http://www.nocodb.com/) community [Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)