I see that `A1012` is followed by a dash. Is this also the case with `A207` and `KH108`? If so, you could do something like
WHERE substr(partner_sku, 1, instr(partner_sku, '-')-1) IN ('A1012', 'A207', 'KH108')
---
Now, the point about normalization is this. It appears that the prefix of `partner_sku` has a special meaning. In this case, the database may benefit from breaking it out into a separate column, say `base_model_id`, that you can then directly search on.