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

0 vote156 views1 answer
Sql create and grant user access to database
SQL
14 votes122 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote125 views1 answer
Postgres list tables and row counts
SQL
0 vote119 views1 answer
Difference between varchar and varchar2
SQL
0 vote122 views1 answer
Mysqldump ignore table
SQL
0 vote161 views5 answers
Select concat alter table mysql
SQL
0 vote140 views1 answer
Least spark sql
SQL
0 vote146 views1 answer
Mysql export data with a where clause
SQL
4 votes83 views1 answer
And or sql order of operations
SQL
0 vote126 views1 answer
Oracle INTERVAL DAY to second to number
SQL