Mariadb json select

+----+--------+-------+-------+---------------------------------+
| id | name   | price | stock | attr                            |
+----+--------+-------+-------+---------------------------------+
|  2 | Shirt  | 10.50 |    78 | {"size": 42, "colour": "white"} |
|  3 | Blouse | 17.00 |    15 | {"colour": "white"}             |
+----+--------+-------+-------+---------------------------------+
  
SELECT name FROM clothes WHERE JSON_EXTRACT(attr, '$.size') = 42;

Similar codes

2 votes231 views1 answer
Postgresql create table as select
SQL
0 vote229 views3 answers
Classement rang mysql 7
SQL
0 vote237 views1 answer
T-sql email validation
SQL
0 vote221 views1 answer
Oracle procedure teamplate
SQL
0 vote210 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
2 votes221 views2 answers
How to DROP a table in mysql
SQL
0 vote228 views1 answer
Create function in microsoft sql server
SQL
0 vote212 views1 answer
Sql server pivot rows to columns
SQL
3 votes226 views2 answers
Oracle apex view logs
SQL
0 vote225 views2 answers
How to install mssql on mac
SQL