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

0 vote179 views1 answer
Resullt all update knex mysql
SQL
0 vote133 views1 answer
Kannst du deine finger trainieren
SQL
1 vote223 views1 answer
Postgresql if 0 then 1
SQL
0 vote188 views1 answer
Declarative base sqlalchemy
SQL
4 votes197 views2 answers
What is table in sql
SQL
0 vote177 views1 answer
Sql find leading space
SQL
2 votes208 views1 answer
Sqlite insert if not exists
SQL
0 vote173 views1 answer
Lost connection to mysql
SQL
4 votes192 views4 answers
Check constraint in ms sql
SQL
0 vote208 views1 answer
Sql server insert inner join
SQL