How to query attribute from JSON data in mysql ?

Question

3.15K viewsFebruary 6, 2020Programmingattribute column JSON query SQL

0

Write your answer.

goli202084 · Answer 1 · 2020-02-06T00:49:32+00:00

select * from `<table_name>` where <column_name> REGEXP '"<key>":"<value>"';

Should do the trick of looking JSON attribute by key/value pair match.