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

16 votes324 views3 answers
Update table from another table
SQL
0 vote297 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
1 vote288 views1 answer
Scaffold mysql database
SQL
0 vote298 views1 answer
Where case insensitive like mysql
SQL
0 vote308 views1 answer
How to connect pgadmin with excel
SQL
20 votes360 views4 answers
Sql count if
SQL
17 votes364 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote289 views1 answer
AddEntityFrameworkSqlite
SQL
3 votes306 views1 answer
Mysql set field unique
SQL
0 vote305 views1 answer
Char vs varchar2 in sql
SQL