Query to remove summoning
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 ..
|