Remove the 0, from set special_abilities = '0,' so you just use ' ' (like below).
Works, removing over 4K entries :P
Code:
update npc_types set special_abilities = '' + substring(special_abilities, 2, length(special_abilities)-2) where special_abilities like '1,%';