How to query attribute from JSON data in mysql ?

1.95K 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
You are viewing 1 out of 1 answers, click here to view all answers.
Write your answer.

Categories