Here is my table:
| ID | parts_new | parts_old |
|---|---|---|
| 1 | 1/X, 2/X | 1/X, 1/X, 1/Y, 2/X |
| 2 | 1/X, 2/Y, 1/Y | 1/X, 1/X, 2/Y, 1/Z, 1/Y |
| 3 | 1/X, 3/Z, 3/Z | 1/X, 1/X, 2/Y, 1/Y |
| … |
I would like to show all rows where not all distinct parts_new items are available in parts_old.
As a result want to see:
| ID | parts_new | parts_old |
|---|---|---|
| 3 | 1/X, 3/Z, 3/Z | 1/X, 1/X, 2/Y, 1/Y |
I tried to use FIND_IN_SET I get incorrect results.
where FIND_IN_SET(parts_new,parts_old)=0
1