sql command help

Hello!

I have 1000+ bad row in creature_loot_template (chance -99, -10 etc)

How do I delete them ’ - ’ ?

-99 = 99

-10 = 10

UPDATE creature_loot_template SET Chance = ‘’ WHERE creature_loot_template.Chance = -; ?

update table set column = abs(coumn)try something like this.

Always make a backup before trying some random SQL codes

Good!

Thanks for help! /emoticons/default_smile.png