Had one when I was 23.
Cue severe embarrassment when the nurses came around to to my bed to "administer" the colon cleansing procedure , believe nowadays they give you a laxative to drink the night before.
Got a mild sedative and it was not painful at all.