[Slaymore]

HI,

I can not wrap my head around the query I need to remove just the 1,1^ from the special_abilities entries..

running this:

SELECT * FROM npc_types WHERE special_abilities like "1,1^%";

gets me 1702 entries .. i suppose I could manually remove the 1,1^ from the front of them all.. but hoping there is a sql command that can automate it ..