# O data explorer suporta extrações JSON?

**URL:** <https://meta.discourse.org/t/does-the-data-explorer-support-json-extracts/256666>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [1 Março , 2023 11:40 UTC](https://meta.discourse.org/t/does-the-data-explorer-support-json-extracts/256666 "2023-03-01T11:40:20Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![leonardo](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/leonardo/32/228634_2.png) [@leonardo](https://meta.discourse.org/u/leonardo)\
**Post date:** [1 Março , 2023 12:28 UTC](https://meta.discourse.org/t/does-the-data-explorer-support-json-extracts/256666/2 "2023-03-01T12:28:29Z")

</div>

Olá!

Essa é uma função do MySQL, mas o [Data Explorer](https://meta.discourse.org/t/32566?silent=true) consulta o banco de dados PostgreSQL do Discourse em vez disso.

Com base em [esta resposta do SO](https://stackoverflow.com/a/41248854), você está procurando o operador `@>` do Postgres para tipos de dados JSON:

> **[9.16. JSON Functions and Operators](https://www.postgresql.org/docs/current/functions-json.html)**
>
> 9.16. JSON Functions and Operators # 9.16.1. Processing and Creating JSON Data 9.16.2. The SQL/JSON Path Language 9.16.3. SQL/JSON Query Functions …

---

_[View the full topic](https://meta.discourse.org/t/does-the-data-explorer-support-json-extracts/256666)._