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

2 votes108 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote115 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote105 views1 answer
Mysql date format unix timestamp
SQL
0 vote88 views1 answer
Java spring boot connect to sql server
SQL
2 votes108 views1 answer
Q operator in oracle
SQL
7 votes73 views1 answer
Mysql load data infile csv
SQL
2 votes147 views3 answers
Xampp mysql database not starting
SQL
0 vote103 views1 answer
Sql find leading space
SQL
0 vote65 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
9 votes104 views4 answers
SQL Date Format
SQL