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 vote250 views1 answer
Oracle running queries
SQL
0 vote191 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote263 views2 answers
Uninstall postgresql mac
SQL
0 vote244 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
24 votes208 views5 answers
List mysql users
SQL
1 vote198 views1 answer
Load sql into mamp
SQL
6 votes218 views1 answer
T-sql test if table exists
SQL
1 vote222 views1 answer
Drop colum oracle 18c
SQL
0 vote240 views1 answer
Sql convert float to string
SQL
14 votes235 views2 answers
Sql cast
SQL