How to query attribute from JSON data in mysql ?
select * from `<table_name>` where <column_name> REGEXP '"<key>":"<value>"';
Should do the trick of looking JSON attribute by key/value pair match.
goli202084 Changed status to publish
select * from `<table_name>` where <column_name> REGEXP '"<key>":"<value>"';
Should do the trick of looking JSON attribute by key/value pair match.