# שימוש באופרטור IN ב-Data Explorer

**URL:** <https://meta.discourse.org/t/using-the-in-operator-in-data-explorer/310503>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [4 ביוני,‏ 2024,‏ 12:27pm UTC](https://meta.discourse.org/t/using-the-in-operator-in-data-explorer/310503 "2024-06-04T12:27:04Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![albertocottica](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/albertocottica/32/119622_2.png) [@albertocottica](https://meta.discourse.org/u/albertocottica)\
**Post date:** [4 ביוני,‏ 2024,‏ 12:27pm UTC](https://meta.discourse.org/t/using-the-in-operator-in-data-explorer/310503/1 "2024-06-04T12:27:04Z")

</div>

Hi all, I noticed a strange behavior when editing and running a query in [Data Explorer](https://meta.discourse.org/t/32566?silent=true). I am trying to use the `WHERE` and `IN` operators to select only posts from topics in certain categories:

```plaintext
WHERE
    t.category_id IN (420, 421, 426)

```

However, I am not sure that the `WHERE` condition works as expected: if I run the query for periods antecedent the creation of the categories in question, it simply lists all topics, regardless of the category. Additionally, the `IN` operator does not change colour, and I wonder if [Data Explorer](https://meta.discourse.org/t/32566?silent=true) recognizes is as an operator:

 ![The image shows a few lines of SQL code, performing a JOIN operation on a table and filtering the results based on category IDs being part of a specific set of values. (Captioned by AI)](https://global.discourse-cdn.com/meta/original/4X/4/7/b/47bec1d60bdc49a68690db27cd42433a9affce63.png)

Any idea what is going on? Huge thanks!

---

_[View the full topic](https://meta.discourse.org/t/using-the-in-operator-in-data-explorer/310503)._