0

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.

Improve this question

1 Answer 1

Reset to default
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/

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.