Grrr MySQL please Help

[timyarb]

OK So with the database updates I have to go in and manually remove to Immune to magic (B) from the npc_types table each time. I can edit and change columns in the database if the entire record is changed (like changing no trade items to tradable) but the ability to remove the "Immune to Magic" only from the record is escaping me. I have scoured the internet looking for a way to do it but this is a classic evample of the blind leading the blind.

So my question is this is there a SQL command/query I can run that will allow me to remove the "B" from the column "npcspecialattks" in the table "npc_types" from the "peq" databse, while preserving any other entries contained in the column?

I hope that makes sense, I am such a MySQL noob it is not even funny.

Tim

[pfyon]

You should be able to use a query like the following:

UPDATE peq.npc_types SET npcspecialattks = replace(npcspecialattks,'B','');

That'll replace every occurrance of 'B' in the npcspecialattks column with nothing.

[timyarb]

Pfyon YOU ROCK... Thank you that worked perfect.