Does a urinary catheter hurt?

I am 32 weeks into my pregnancy. Every single time I go to the doctor they have to check for UTI as I suffered from constantly getting them from the age of 4-15. I just got a phone call saying that there was a bit of bacteria found on the last urine sample and to make sure that the next sample I give them is a clean catch they will insert a urinary catheter on my next visit (33 weeks). Does it hurt?! I just want to mentally prepare myself. thanks!