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 votes143 views1 answer
Postgresql drop primary key constraint
SQL
0 vote145 views2 answers
Mysql dump database tables only
SQL
1 vote123 views1 answer
Tsql update datetime
SQL
6 votes136 views4 answers
How to remove unique key in mysql
SQL
0 vote134 views1 answer
Postgresql parse json array
SQL
1 vote145 views1 answer
Age postgres
SQL
2 votes150 views1 answer
Drop sequence
SQL
0 vote131 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote179 views1 answer
Display all node label neo4j
SQL
1 vote137 views1 answer
Restart identity postgresql
SQL