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

8 votes340 views1 answer
Insert a select statement into a table
SQL
0 vote352 views1 answer
Make a socket server to detect changes in mysql
SQL
9 votes378 views6 answers
Oracle substring
SQL
-1 vote355 views1 answer
MYSQL stored procedure select from
SQL
1 vote393 views2 answers
Mysql add column tinyint default 0
SQL
0 vote384 views2 answers
Dbms transaction tutorialspoint
SQL
4 votes343 views1 answer
Delete record mysql query
SQL
0 vote357 views1 answer
Remove binlog mysql
SQL
1 vote391 views1 answer
Sql view where tables have same column name combine results
SQL
3 votes330 views2 answers
Oracle for loop
SQL