How to filter records by data contained in json?

Question

There is a table test. The table has 2 columns: id, json_data. This table has entries:

1 {"f_20550": [77, 255, 666]} 2 {"f_20550": [77, 255]} 2 {"f_20550": [77, 66]}

Task: to find all records for which the f_20550 property in the array has an element 77.

What version of mysql are you using and what type of data does json_data have ?
1 {"f_20550": [77, 255, 666]} 2 {"f_20550": [77, 255]} 3 {"f_20550": [77, 66]}
On good should be so SELECT JSON_SEARCH (CAST (json_data -> "$. F_20550" AS JSON), 'one', '77') from t1;
But why bring CAST (json_data -> "$. F_20550" AS JSON, if the column is JSON and so

Denis 8,358 6 nineteen 49 · Answer 1 · 2016-07-28T07:38:02

 SELECT * FROM test WHERE JSON_CONTAINS( `json_data`, '77', '$.f_20550');

1 answer 1