Does the data explorer support json extracts?

[leonardo (Leonardo Mosquera)]

Hi!

That is a MySQL function, but Data Explorer queries Discourse’s PostgreSQL database instead.

Based on this SO answer, you’re looking for Postgres’ @> operator for JSON data types:

9.16. JSON Functions and Operators