View Single Post
  #2  
Old 09-12-2011, 12:48 PM
sorvani
Dragon
 
Join Date: May 2010
Posts: 965
Default

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
Reply With Quote