To want the ground to swallow you up / To be mortified
Literally 'not to know where to put oneself'. Describes extreme embarrassment where you wish you could disappear.
When she fell in front of everyone she wanted the ground to swallow her up.
I said the wrong name and I wanted the ground to swallow me up.
—How did you feel? —I was mortified, it was awful.