MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT VERSION();


VERSION()


8.0.30


SET @`properties` := '
{
  "images":
    [
      {
        "original": "path/to/original",
        "icon": "path/to/icon",
        "small": "path/to/small"
      },
      {
        "original": "path/to/original"
      }
    ]
}
';
SELECT JSON_CONTAINS_PATH(@`properties`, 'one', '$.images') AND
       IFNULL(JSON_LENGTH(
         JSON_SEARCH(@`properties`, 'all', '%', NULL, '$.images[*].icon')
       ) = @`MAX_LENGTH`, 0) AND
       IFNULL(JSON_LENGTH(
         JSON_SEARCH(@`properties`, 'all', '%', NULL, '$.images[*].small')
       ) = @`MAX_LENGTH`, 0)
FROM (SELECT @`MAX_LENGTH` := JSON_LENGTH(@`properties`, '$.images')) `der`;


JSON_CONTAINS_PATH(@`properties`, 'one', '$.images') AND
       IFNULL(JSON_LENGTH(
         JSON_SEARCH(@`properties`, 'all', '%', NULL, '$.images[*].icon')
       ) = @`MAX_LENGTH`, 0) AND
       IFNULL(JSON_LENGTH(
         JSON_SEARCH(@`properties`, '


0


SET @`properties` := '
{
  "images":
    [
      {
        "original": "path/to/original",
        "icon": "path/to/icon",
        "small": "path/to/small"
      },
      {
        "original": "path/to/original",
        "icon": "path/to/icon",
        "small": "path/to/small"
      }
    ]
}
';
SELECT JSON_CONTAINS_PATH(@`properties`, 'one', '$.images') AND
       IFNULL(JSON_LENGTH(
         JSON_SEARCH(@`properties`, 'all', '%', NULL, '$.images[*].icon')
       ) = @`MAX_LENGTH`, 0) AND
       IFNULL(JSON_LENGTH(
         JSON_SEARCH(@`properties`, 'all', '%', NULL, '$.images[*].small')
       ) = @`MAX_LENGTH`, 0)
FROM (SELECT @`MAX_LENGTH` := JSON_LENGTH(@`properties`, '$.images')) `der`;


JSON_CONTAINS_PATH(@`properties`, 'one', '$.images') AND
       IFNULL(JSON_LENGTH(
         JSON_SEARCH(@`properties`, 'all', '%', NULL, '$.images[*].icon')
       ) = @`MAX_LENGTH`, 0) AND
       IFNULL(JSON_LENGTH(
         JSON_SEARCH(@`properties`, '


1