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 votes209 views2 answers
Mysql remove only_full_group_by permanently
SQL
1 vote190 views3 answers
Sql server get week dates from week number
SQL
0 vote268 views1 answer
Sql server sleep
SQL
1 vote196 views1 answer
Postgresql substring last
SQL
0 vote188 views1 answer
Sqlite update only if greater
SQL
3 votes204 views1 answer
Convert sqlite table to pandas dataframe
SQL
2 votes208 views1 answer
How to get weekday from old date in sql
SQL
0 vote221 views4 answers
What is unique key in sql
SQL
0 vote247 views1 answer
Download mysql database to excel in android studio
SQL
0 vote184 views1 answer
Mysql server not starting in xampp in mac
SQL