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

1 vote180 views1 answer
Add constraint sql
SQL
2 votes190 views1 answer
Enum in SQL Server
SQL
0 vote242 views9 answers
Linq to sql converter online
SQL
3 votes185 views2 answers
Plsql print
SQL
2 votes244 views2 answers
Mysql date range
SQL
0 vote189 views1 answer
Hoq to import database source
SQL
0 vote184 views1 answer
Pl sql constraint user function
SQL
1 vote222 views1 answer
Mysql return text after a final full stop
SQL
0 vote189 views2 answers
Close external port 3306 with iptables
SQL
2 votes184 views1 answer
Alter table add multiple columns postgresql
SQL