Changing an entire column

[ryder911]

So I am trying to update the start zone on my server. I want all of the columns to be the same location - is there any way to do this other the by hand?

[pfyon]

update start_zones set start_zone=somezoneid

Since the above does not have a WHERE condition, it will apply it to every row in the table. You'll have to go through and make sure the rest of the columns in that table to make sure that it all works, but that's the syntax you'll need to use.

edit: You need to set somezoneid to whatever zone id you wanted to use.