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

0 vote233 views1 answer
Java sql timestamp now
SQL
5 votes195 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote223 views1 answer
Display all node label neo4j
SQL
-1 vote192 views3 answers
Mysql get age from date
SQL
33 votes224 views6 answers
Sql delete
SQL
1 vote194 views2 answers
Populate sql table with random data
SQL
15 votes210 views6 answers
Psql
SQL
0 vote204 views1 answer
Convert .mdf to .bak
SQL
0 vote212 views2 answers
How to install mssql on mac
SQL
2 votes209 views1 answer
Oracle run_duration average
SQL