In this blog post, we’ll discuss JSON document
fast lookup with MySQL 5.7.
Recently I attended Morgan Tocker’s talk on MySQL 5.7 and JSON at
FOSDEM, and I found it awesome.
I learned some great information from the talk. Let me share one
of them here: a very useful trick if you plan to store JSON
documents in your MySQL database and want to retrieve the
documents from some attribute’s values. So let’s look at how to
do JSON document fast lookup with MySQL 5.7!
In this short example, I show you how we can speed up this type
of search using JSON functions and virtual columns.
This our test table:
Create Table: CREATE TABLE …[Read more]