piercings

so I want a hood peircing but I have a fear of needles and I don't know how badly it will hurt. I have a pain tolerance of "I can break my leg falling down stairs and only cry for an hour then fall asleep" and "I just stubbed my toe so I'm going to cry for 3 hours and eat icecream and not walk because it's still throbbing" would it hurt or would I just be imaging it? please help?