My mom got hers done and said it hurt soooooo bad. I really want mine done too but I'm terrified about the needle and pain.even if it wouldn't hurt,id make myself think it would right before, and I would scream.I'd say I have a low low low pain tollerance.
I also have 2 ear cartilage piercings and I need to know the pain compared to those piercings
Ps (I iced the cartilage piercing and didn't feel ANYTHING)

If you were fine during the cartilage, the nose will be fine. With any kind of puncture, there will be some discomfort.