How to filter by json values in mysql

Someone will jump in here soon.

I searched for JSON and found this thread which goes off in another direction, but does start out with a simple snippet to get a data array from a JSON file. Maybe it can help