I've had my nose pierced (really want to get it done again) and it hurt for the inital piercing, but after that it didn't. I forgot about it like 5 min after.
I've always had my tongue pierced, and I didn't think about it at all, and it didn't really hurt. My tongue was fine that night, but the next morning it was swollen. I had to eat ice and I had those slim fast meals because you can't eat anything hot. In about 3 days it was fine. Just watch out with eating spaghetti after it's healed. I did that and it kinda wrapped around the piercing
Sadly I took it out about 4 months ago. I miss it because i'd play with it when I was bored, but I figured for the whole work place thing, it would be better if I didn't have one.