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

1 vote264 views2 answers
Begin transaction in sql
SQL
0 vote309 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote244 views1 answer
SQL get max per id
SQL
150 votes444 views10 answers
Grepper
SQL
0 vote272 views1 answer
Multiple replace value mssql
SQL
0 vote255 views1 answer
Equi joins in oracle
SQL
4 votes257 views1 answer
What are the data types in sql
SQL
0 vote278 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
2 votes268 views1 answer
Query to check cpu utilization in oracle database
SQL
7 votes259 views3 answers
Select latest entry in sql table
SQL