mysql> select * from test;
+----+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | properties |
+----+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 5 | {"sku": "AAN9L9HA25", "images": [{"icon": "termek-kepek/5/5b44e4b0acccd_ikon.jpg", "small": "termek-kepek/5/5b44e4b0acccd_kis.jpg", "original": "termek-kepek/5/5b44e4b0acccd.jpg"}, {"original": "termek-kepek/5/5b44e628b6e81.jpg"}]} |
| 6 | {"sku": "AAN9L9HA33", "images": []} |
| 9 | {"sku": "AAN9N9HA32", "images": []} |
+----+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0,01 sec)

mysql> select * from test WHERE JSON_CONTAINS_PATH(properties, 'one', '$.images') and JSON_CONTAINS_PATH(properties,'all','$.images[*].icon','$.images[*].small') = 0;
+----+-------------------------------------+
| id | properties |
+----+-------------------------------------+
| 6 | {"sku": "AAN9L9HA33", "images": []} |
| 9 | {"sku": "AAN9N9HA32", "images": []} |
+----+-------------------------------------+
2 rows in set (0,00 sec)