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

5 votes253 views1 answer
How to get all table names in sql query
SQL
19 votes233 views6 answers
What is mySQL
SQL
2 votes197 views2 answers
Mysql get last character of string
SQL
1 vote255 views2 answers
Extract weekday from date in sql
SQL
4 votes234 views3 answers
How to describe a table in sqlite3
SQL
1 vote236 views3 answers
Connection string mysql
SQL
1 vote237 views1 answer
Sql where last 12 months
SQL
0 vote235 views1 answer
St_buffer mysql
SQL
2 votes242 views3 answers
Mysql pass command from command line
SQL
0 vote250 views1 answer
How to delete duplicate rows in oracle
SQL