Quote:
|
Originally Posted by Secrets
Think this would be it...
Code:
UPDATE `npc_types` SET `npcspecialattks`='F' WHERE `level` > 35 AND level < 65
Would set the flag 'F' in the field `npcspecialattks` where the level is 36-64. |
mysql supports a concat function, you might be able to use something like:
Code:
UPDATE `npc_types`
SET `npcspecialattks`= concat( `npcspecialattks`, 'F' )
WHERE `level` > 35 AND level < 65
AND `npcspecialattks` not like '%F%'