I had one for an operation on my stomach just a little over a month ago and I didn't think it hurt at all. Maybe a tiny pinch like you're getting a shot but not as painful.
Yes, you can feel it when they do the injection. But believe me, it's worth it! Nothing like the pain that you have without it.
Love from a mother of two.