SQL Query Help For NPCSpecialAttks Please

BMXWoody · #1 08-13-2009, 11:21 AM

G'day guys, I'm not at all experienced with SQL but I've somehow managed to stumble through setting up and modifying my server without any trouble up until now.

I'm just trying to remove the summon ability from ALL NPCs in my server and I'm hoping someone can tell me how to drop the S value from the npcspecialattks column in the npc_types table. I've tried using UPDATETEXT and REPLACE functions but as I said, I really have no knowledge at all in SQL so I haven't had any luck.

I did have a pretty good look through the forums and the wiki for help but couldn't find anything. Hopefully I haven't missed a glaringly obviously tutorial or something.

Thanks in advance for any help you guys can offer.
Cheers,
BMXWoody.

**joligario** · #2 08-13-2009, 12:29 PM

I don't have the database with me at work, so my column names might be off, but I think it will be something like this:

Code:

UPDATE npc_types SET npcspecialattks = REPLACE (npcspecialattks, 'S', '');

BMXWoody · #3 08-13-2009, 05:02 PM

Lol so simple, the commands I was typing were really long and complex. Thanks heaps for that mate!! I'll give it a shot right now and let you know how it works when i get a chance to test it later =D
Cheers,
BMXWoody.

BMXWoody · #4 08-15-2009, 11:18 PM

Worked like a dream mate. Thanks again!!

BMXWoody