Creating profile urls (with mod_rewrite?)

I want to convert my profiles from this sort:

http://www.mysite.com/profile.php?id=4

to this:

http://www.mysite.com/farmersmarket

where 'farmersmarket' is, of course, the username.
I assume mod_rewrite is the way to go.
Could anyone possibly help me out?
I greatly appreciate it.