This is what I use. Its not the most elegant SQL but it works.
Code:
-- Need to run on the copied spell table prior to updating file so that NPC cast dots don't cause HP bounce on clients.
UPDATE spells_new_copy SET effect_base_value1 = -1 WHERE buffduration >= 1 AND goodEffect = 0 AND effectid1 = 0 AND effect_base_value1 < 0 AND classes1 = 255 AND classes1 = 255 AND classes2 = 255 AND classes3 = 255 AND
classes4 = 255 AND classes5 = 255 AND classes6 = 255 AND classes7 = 255 AND classes8 = 255 AND classes9 = 255 AND classes10 = 255 AND classes11 = 255 AND classes12 = 255 AND classes13 = 255 AND classes14 = 255 AND classes15 = 255
AND classes16 = 255 AND descnum <= 400000;
UPDATE spells_new_copy SET effect_base_value2 = -1 WHERE buffduration >= 1 AND goodEffect = 0 AND effectid2 = 0 AND effect_base_value2 < 0 AND classes1 = 255 AND classes1 = 255 AND classes2 = 255 AND classes3 = 255 AND
classes4 = 255 AND classes5 = 255 AND classes6 = 255 AND classes7 = 255 AND classes8 = 255 AND classes9 = 255 AND classes10 = 255 AND classes11 = 255 AND classes12 = 255 AND classes13 = 255 AND classes14 = 255 AND classes15 = 255
AND classes16 = 255 AND descnum <= 400000;
UPDATE spells_new_copy SET effect_base_value3 = -1 WHERE buffduration >= 1 AND goodEffect = 0 AND effectid3 = 0 AND effect_base_value3 < 0 AND classes1 = 255 AND classes1 = 255 AND classes2 = 255 AND classes3 = 255 AND
classes4 = 255 AND classes5 = 255 AND classes6 = 255 AND classes7 = 255 AND classes8 = 255 AND classes9 = 255 AND classes10 = 255 AND classes11 = 255 AND classes12 = 255 AND classes13 = 255 AND classes14 = 255 AND classes15 = 255
AND classes16 = 255 AND descnum <= 400000;
UPDATE spells_new_copy SET effect_base_value4 = -1 WHERE buffduration >= 1 AND goodEffect = 0 AND effectid4 = 0 AND effect_base_value4 < 0 AND classes1 = 255 AND classes1 = 255 AND classes2 = 255 AND classes3 = 255 AND
classes4 = 255 AND classes5 = 255 AND classes6 = 255 AND classes7 = 255 AND classes8 = 255 AND classes9 = 255 AND classes10 = 255 AND classes11 = 255 AND classes12 = 255 AND classes13 = 255 AND classes14 = 255 AND classes15 = 255
AND classes16 = 255 AND descnum <= 400000;
UPDATE spells_new_copy SET effect_base_value5 = -1 WHERE buffduration >= 1 AND goodEffect = 0 AND effectid5 = 0 AND effect_base_value5 < 0 AND classes1 = 255 AND classes1 = 255 AND classes2 = 255 AND classes3 = 255 AND
classes4 = 255 AND classes5 = 255 AND classes6 = 255 AND classes7 = 255 AND classes8 = 255 AND classes9 = 255 AND classes10 = 255 AND classes11 = 255 AND classes12 = 255 AND classes13 = 255 AND classes14 = 255 AND classes15 = 255
AND classes16 = 255 AND descnum <= 400000;
UPDATE spells_new_copy SET effect_base_value6 = -1 WHERE buffduration >= 1 AND goodEffect = 0 AND effectid6 = 0 AND effect_base_value6 < 0 AND classes1 = 255 AND classes1 = 255 AND classes2 = 255 AND classes3 = 255 AND
classes4 = 255 AND classes5 = 255 AND classes6 = 255 AND classes7 = 255 AND classes8 = 255 AND classes9 = 255 AND classes10 = 255 AND classes11 = 255 AND classes12 = 255 AND classes13 = 255 AND classes14 = 255 AND classes15 = 255
AND classes16 = 255 AND descnum <= 400000;
UPDATE spells_new_copy SET effect_base_value7 = -1 WHERE buffduration >= 1 AND goodEffect = 0 AND effectid7 = 0 AND effect_base_value7 < 0 AND classes1 = 255 AND classes1 = 255 AND classes2 = 255 AND classes3 = 255 AND
classes4 = 255 AND classes5 = 255 AND classes6 = 255 AND classes7 = 255 AND classes8 = 255 AND classes9 = 255 AND classes10 = 255 AND classes11 = 255 AND classes12 = 255 AND classes13 = 255 AND classes14 = 255 AND classes15 = 255
AND classes16 = 255 AND descnum <= 400000;
UPDATE spells_new_copy SET effect_base_value8 = -1 WHERE buffduration >= 1 AND goodEffect = 0 AND effectid8 = 0 AND effect_base_value8 < 0 AND classes1 = 255 AND classes1 = 255 AND classes2 = 255 AND classes3 = 255 AND
classes4 = 255 AND classes5 = 255 AND classes6 = 255 AND classes7 = 255 AND classes8 = 255 AND classes9 = 255 AND classes10 = 255 AND classes11 = 255 AND classes12 = 255 AND classes13 = 255 AND classes14 = 255 AND classes15 = 255
AND classes16 = 255 AND descnum <= 400000;
UPDATE spells_new_copy SET effect_base_value9 = -1 WHERE buffduration >= 1 AND goodEffect = 0 AND effectid9 = 0 AND effect_base_value9 < 0 AND classes1 = 255 AND classes1 = 255 AND classes2 = 255 AND classes3 = 255 AND
classes4 = 255 AND classes5 = 255 AND classes6 = 255 AND classes7 = 255 AND classes8 = 255 AND classes9 = 255 AND classes10 = 255 AND classes11 = 255 AND classes12 = 255 AND classes13 = 255 AND classes14 = 255 AND classes15 = 255
AND classes16 = 255 AND descnum <= 400000;
UPDATE spells_new_copy SET effect_base_value10 = -1 WHERE buffduration >= 1 AND goodEffect = 0 AND effectid10 = 0 AND effect_base_value10 < 0 AND classes1 = 255 AND classes1 = 255 AND classes2 = 255 AND classes3 = 255 AND
classes4 = 255 AND classes5 = 255 AND classes6 = 255 AND classes7 = 255 AND classes8 = 255 AND classes9 = 255 AND classes10 = 255 AND classes11 = 255 AND classes12 = 255 AND classes13 = 255 AND classes14 = 255 AND classes15 = 255
AND classes16 = 255 AND descnum <= 400000;
UPDATE spells_new_copy SET effect_base_value11 = -1 WHERE buffduration >= 1 AND goodEffect = 0 AND effectid11 = 0 AND effect_base_value11 < 0 AND classes1 = 255 AND classes1 = 255 AND classes2 = 255 AND classes3 = 255 AND
classes4 = 255 AND classes5 = 255 AND classes6 = 255 AND classes7 = 255 AND classes8 = 255 AND classes9 = 255 AND classes10 = 255 AND classes11 = 255 AND classes12 = 255 AND classes13 = 255 AND classes14 = 255 AND classes15 = 255
AND classes16 = 255 AND descnum <= 400000;
UPDATE spells_new_copy SET effect_base_value12 = -1 WHERE buffduration >= 1 AND goodEffect = 0 AND effectid12 = 0 AND effect_base_value12 < 0 AND classes1 = 255 AND classes1 = 255 AND classes2 = 255 AND classes3 = 255 AND
classes4 = 255 AND classes5 = 255 AND classes6 = 255 AND classes7 = 255 AND classes8 = 255 AND classes9 = 255 AND classes10 = 255 AND classes11 = 255 AND classes12 = 255 AND classes13 = 255 AND classes14 = 255 AND classes15 = 255
AND classes16 = 255 AND descnum <= 400000;