It's gonna be tricky...
Code:
SELECT `id`, REPLACE(`special_abilities`, '1,1^', '[DELETED]^') FROM `npc_types` WHERE `special_abilities` LIKE '1,1^%' UNION ALL
SELECT `id`, REPLACE(`special_abilities`, '1,1', '[DELETED]') FROM `npc_types` WHERE `special_abilities` LIKE '1,1'
ORDER BY `id`
Looking at `id` 21164, you can see a false hit.
That means that the criteria has to be perfect or you will corrupt your entries.
It can be done..but, it'll take a little more thought than I can put into it atm.