How do I edit multiple rows in a table?

[jimb0t]

I need to find a way to edit multiple entries of an item in my table without having the need to go through each one of them individually. There are 36,000 records and that would be a very huge pain to have to do that.

 

However I only want certain ones to be edited assuming they match another value in the row. Please see the attached image to get a better idea of what I am trying to say.

 

 

This is part of my jos_postalcodes3 table. This is one example of what I am trying to do. Of course I need to do a whole lot more but hopefully it is a simple piece of code I can work off of.

 

 

Thanks in advance for the help.

[veridicus]

UPDATE jos_postalcodes3 SET countyname = 'Albany (NY)' WHERE county_zip = 36001;