Navicat Query

[Supah]

What would a query look like to set a whole column in a table to zero?

[covert_cat]

I don't know why you would need to do this.. but the SQL query would be something like:

example:

UPDATE `creature_names`
SET name='Waffle Eater'
WHERE name='Flesh Eater';

This changes the npc with the name "Flesh Eater" to the name "Waffle Eater"

UPDATE table_name
SET column1=value

Explanation: Replace table_name with your table's name(eg items) Replace column1 with the name of the column(eg existingduration) and replace value with your chosen value(eg 0)
This would remove item durations.
But be EXTREMELY CAREFUL. YOU COULD WRECK YOUR ENTIRE TABLE. DON'T BLAME ME

[marcelo_20xx]

UPDATE 'nameofthetable' SET 'nameofthecolumn' = 0;

[covert_cat]

UPDATE 'nameofthetable' SET 'nameofthecolumn' = 0;

Pretty much what I just said..