By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
12 rows affected
| COLUMN1 | COLUMN2 | COLUMN3 | COLUMN4 |
|---|---|---|---|
| items1 | car | car | 1 |
| items2 | car,car | car | 2 |
| items3 | car,toy,car | toy | 1 |
| items4 | car,toy,toy | toy | 2 |
| items5 | car,toy,cards | toy | 1 |
| items6 | toy,cards,cards | toy | 1 |
| items7 | toy,cards,toy | toy | 2 |
| items8 | car,cards,toy,cards | cards | 2 |
| items9 | car,cards,cards | cards | 2 |
| items10 | toy,cards,car | toy | 1 |
| items11 | scar,cards,scar,scar | scar | 3 |
| items12 | car,car,cards,car | cards | 1 |