# HubDB Not Equals Filter On Multiple Values

**URL:** <https://community.hubspot.com/t/hubdb-not-equals-filter-on-multiple-values/37519>\
**Category:** CMS Development\
**Created:** [May 18, 2021, 4:43pm UTC](https://community.hubspot.com/t/hubdb-not-equals-filter-on-multiple-values/37519 "2021-05-18T16:43:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![SirHubalot](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sirhubalot/32/13631_2.png) [@SirHubalot](https://community.hubspot.com/u/SirHubalot)\
**Post date:** [May 18, 2021, 4:43pm UTC](https://community.hubspot.com/t/hubdb-not-equals-filter-on-multiple-values/37519/1 "2021-05-18T16:43:58Z")

</div>

Hi,

I have a value in a variable that contains comma-separeted values of category names.

What I would like to do is pass this to my HubDB filter query to get back a list of records where those categories are not equal to the data.

Would be the approach of doing this?

```lia-code-sample
{% set categories = "Category1, Category2, Category3" %}
{% set unused_categories = hubdb_table_rows(99999,"name__ne="~categories~"&orderBy=name") %}

```

Thanks for any help!

---

<div class="post-metadata">

**Author:** ![dennisedson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dennisedson/32/28044_2.png) [@dennisedson](https://community.hubspot.com/u/dennisedson)\
**Post date:** [May 19, 2021, 3:40pm UTC](https://community.hubspot.com/t/hubdb-not-equals-filter-on-multiple-values/37519/2 "2021-05-19T15:40:42Z")

</div>

@Chris-M , [@Jake\_Lett](https://community.hubspot.com/t5/user/viewprofilepage/user-id/72866) , [@webdew](https://community.hubspot.com/t5/user/viewprofilepage/user-id/131510) , can any of you offer @SirHubalot some guidance?

---

<div class="post-metadata">

**Author:** ![Kevin-C](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kevin-c/32/34570_2.png) [@Kevin-C](https://community.hubspot.com/u/Kevin-C)\
**Post date:** [May 20, 2021, 10:15pm UTC](https://community.hubspot.com/t/hubdb-not-equals-filter-on-multiple-values/37519/3 "2021-05-20T22:15:28Z")

</div>

Hey @SirHubalot

You could use `not_like` just as you would contains, by passing it a comma separated values:

```lia-code-sample
{% set categories = "Category1, Category2, Category3" %}
{% set cats = 'multiselect__not_like='~categories|join(',')%}
{% set table = hubdb_table_rows(XXXXXX, cats) %}

```

Hope this get ya going!