By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.30 |
create table packages (id int, name varchar(10));
insert into packages (id, name) values (1, 'red'), (2, 'blue'), (3, 'yellow');
Records: 3 Duplicates: 0 Warnings: 0
create table contents (packageid int, item varchar(10), size char(1));
insert into contents (packageid, item, size)
values (1, 'square', 'A'), (1, 'circle', 'B'), (1, 'triangle', 'C'),
(2, 'square', 'A'), (2, 'circle', 'B'),
(3, 'square', 'A');
Records: 6 Duplicates: 0 Warnings: 0
select packageid
from contents
group by packageid
having group_concat(concat(item, '|', size) order by item, size separator ',') =
'circle|B,square|A';
| packageid |
|---|
| 2 |