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.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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/