What's the best way to index?

[elfeffe]

I see that this is possible to search using data inside the JSON field, I have fields like:

[{"id": 1, "qty": 0, "sku": "TnvxPOrJIk", "title": "Irix 150mm Dragonfly Canon", "barcode": null, "scanned": 0, "serial_numbers": [], "has_serial_number": 0}, {"id": 8, "qty": 0, "sku": "IL-15BS-PK", "title": "Irix 15mm Blackstone Nikon", "barcode": "7640172190319", "scanned": 0, "serial_numbers": [], "has_serial_number": 1}]

What's the best way to index?

MySQL 8 has some new options to index JSON columns https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-21.html#mysqld-8-0-21-json

Is there any good way?