I did that as a kid when my mate kicked my rod as I was putting the hook on.
It was a barbed hook that went in the tip of my finger and then came out of the side. I went to hospital and they sprayed the finger with a cooling spray, got some pliers and then started yanking/wiggling until it came out....how I didnt pass out I dont know.
The cooling spray number the outside of my finger, but certainly didnt feel like it had numbed the inside.
Not fun.