# Ecto JSONB array 'contains' query

**URL:** <https://forum.elixirforum.com/t/ecto-jsonb-array-contains-query/9676>\
**Category:** Questions\
**Tags:** ecto, jsonb\
**Created:** [October 27, 2017, 12:15pm UTC](https://forum.elixirforum.com/t/ecto-jsonb-array-contains-query/9676 "2017-10-27T12:15:43Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![mechabyte](https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/mechabyte/32/3409_2.png) [@mechabyte](https://forum.elixirforum.com/u/mechabyte)\
**Post date:** [October 27, 2017, 8:11pm UTC](https://forum.elixirforum.com/t/ecto-jsonb-array-contains-query/9676/2 "2017-10-27T20:11:05Z")

</div>

Have you explored using raw SQL queries using Ecto? [Here’s a relevant section](https://hexdocs.pm/ecto/Ecto.Adapters.SQL.html#query/4) in their docs, as well [a related Medium article](https://medium.com/@_elnicky/raw-queries-in-elixir-with-ecto-3240a5892f4f).

---

_[View the full topic](https://forum.elixirforum.com/t/ecto-jsonb-array-contains-query/9676)._