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

10 votes178 views4 answers
Sql pagination
SQL
0 vote209 views1 answer
Sql query inline if
SQL
3 votes187 views1 answer
Postgresql db owner change
SQL
1 vote178 views1 answer
Sql select contem uma palavra
SQL
0 vote167 views1 answer
Sql where time stamp is in between
SQL
0 vote202 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
3 votes188 views2 answers
Get current year sql
SQL
23 votes192 views3 answers
Sql where contains part of string
SQL
-1 vote187 views1 answer
Add bool column in sql
SQL
25 votes171 views6 answers
Modify column name in mysql
SQL