Does getting your nose pierced really hurt?

iv heard it does hurt, but i think on some ppl it looks really nice. id like to get mine done but im a rite wuss n im proper scared lol please no gory details ok!