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

0 vote374 views1 answer
Firebase sql
SQL
0 vote396 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote397 views1 answer
Oracle show grants on table
SQL
0 vote357 views1 answer
Sql dmv to capture updates
SQL
0 vote335 views1 answer
Count the table indatabase
SQL
0 vote337 views1 answer
Check for directory in bash
SQL
0 vote352 views1 answer
Get the previous column of a table in mysql
SQL
0 vote347 views1 answer
Get employees if not contains in sql
SQL
1 vote393 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
0 vote355 views1 answer
Connect to nginx server mysql remotly
SQL