Mariadb JSON_EXTRACT

+----+--------+-------+-------+---------------------------------+
| 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

2 votes190 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote209 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
1 vote219 views1 answer
Set statiscis on in sql server
SQL
0 vote167 views1 answer
Mysql undo delete
SQL
3 votes179 views2 answers
How to load files in mysql
SQL
0 vote191 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote163 views1 answer
Oracle query archive mode
SQL
18 votes175 views3 answers
Find column name in database
SQL
16 votes227 views3 answers
Order by sql query
SQL
0 vote207 views1 answer
Sp help text in postgresql
SQL