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 vote188 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote189 views1 answer
Sql on-premises
SQL
11 votes196 views5 answers
Laravel db facade
SQL
1 vote201 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
5 votes185 views2 answers
Oracle rename table
SQL
65 votes304 views6 answers
Sql add column to table
SQL
0 vote185 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
-1 vote184 views1 answer
Mac mysql workbench console
SQL
2 votes196 views1 answer
Mysql now format
SQL
1 vote186 views1 answer
Launch sql script from docker in mysql
SQL