i believe you have to create a virtual column on specific document fields and create a secondary index on that similar to what you do with Postgres' expression indices, I do not think MySQL has a general JSON GIN index yet