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

6 votes227 views3 answers
Psql show columns of table
SQL
0 vote128 views1 answer
Heavy table in mysql
SQL
0 vote137 views1 answer
Exit psql
SQL
0 vote140 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
6 votes142 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
8 votes126 views3 answers
Postgresql connection string c#
SQL
0 vote118 views1 answer
Call procedure in wordpress
SQL
0 vote128 views2 answers
Plsql regex match whole word
SQL
7 votes136 views5 answers
Show details of table postgres
SQL
0 vote143 views1 answer
Primary key multiple
SQL