Mariadb json select

+----+--------+-------+-------+---------------------------------+
| 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

3 votes115 views1 answer
Select table column in sql
SQL
8 votes126 views1 answer
How to check mysql version in xampp
SQL
1 vote111 views1 answer
Add sequence postgres
SQL
16 votes121 views2 answers
Sql exists
SQL
0 vote114 views1 answer
Jooq replace
SQL
-1 vote109 views1 answer
How to dump .csv file into mysql
SQL
1 vote112 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
3 votes115 views1 answer
Force using index plsql
SQL
0 vote124 views1 answer
Create database like
SQL
0 vote131 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL