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 vote431 views1 answer
Delet all record statment sql
SQL
34 votes351 views6 answers
Install mysql client ubuntu
SQL
8 votes485 views4 answers
Convert date to dd/mm/yyyy sql
SQL
0 vote334 views1 answer
Oracle procedure chain step
SQL
3 votes351 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
4 votes331 views2 answers
Show all database inside postgresql
SQL
0 vote367 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote307 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
4 votes369 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
7 votes334 views3 answers
How ot change name of column mysql
SQL