Question on Navicat Usage

[Emmeric]

I've been altering some spawn rates from Djerv's solo server setup using the spawn2 table in Navicat.

I figured there would be an easy mass way to change these spawn time numbers and I can select a column range just fine but any pasting of a number only effects one field. Navicat Help didn't list a solution either.

I can hold shift down to select multiple entries in a column. Is there a simple way to then change the data in the selected fields all at once?

[sorvani]

when you make a change, look at the bottom of the naivcat window you will see the actual SQL used to make the change.

You can copy that and tweak it a little to do a mass update.

UPDATE `Some_Table` SET `Some_Column` = Your_Value WHERE `Some_Other_Column` = Some_Value

Change the WHERE part to this
WHERE `Some_Other_Column` BETWEEN Some_Start_Value AND Some_End_Value