How to query attribute from JSON data in mysql ?

1.94K viewsProgrammingattribute column JSON query SQL
0
Answered question
0

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

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

Changed status to publish
Write your answer.

Categories