This looks like the right criteria:
Code:
SELECT `id`, CONCAT('[DELETED]^', (SUBSTR(`special_abilities`, 5))) FROM `npc_types` WHERE LEFT(`special_abilities`, 4) 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`
Haven't checked for '1,1' not being at the beginning, though.
EDIT: Adding..
Code:
SELECT `id`, `special_abilities` FROM `npc_types` WHERE `special_abilities` LIKE '%^1,1'
..didn't produce any additional results.