indexable JSON datatype in MySQL/MariaDB

Question

In PostgreSQL 9.4 there is a JSONB datatype which allows you to index on fields in the stored JSON objects. Does MySQL/MariaDB have an equivalent?

I'm specifically interested in the MariaDB Galera cluster, but am open to any MySQL-family answers.

Answer 1

You can do this in MySql 5.7. What you are looking for is adding an index over Generated Columns. You can find an example here: http://mysqlserverteam.com/inline-json-path-expressions-in-mysql-5-7/