moving blog

hello,
I’m trying stuff out on my local server. I’m a bit new to this.
I want to get it working then move it. Is there an easy way to change the URLs in the mysql database to the new location ? I can change them with phpmyadmin but with only 4 posts there are 60 or so instances so it would be a pain to change individually.

thanks

mick