[bowersbros]

I believe that MySQL 5.7 comes with JSON data types too.

https://dev.mysql.com/doc/refman/5.7/en/json.html

[morgo]

Indeed. To expand a little: it has a Json type, functions & virtual columns.

So you can extract part of a Json document and index it. The optimizer can also match Json expressions to indexes