How do you get confidence with women, when everything you've tried has failed?

I genuinely trying to figure it out. My friends keep bothering me on why I won't cold approach women anymore and I'm near 30 and it's getting extremely annoying/frustrating.

I keep telling them, I'm done with cold approaches, it's not worth the remaining confidence I have left towards myself. I had to many bad experiences, and instead don't mean rejection, that's easy. I'm talking about being laughed in the face by these women, them going for my friends in front of me and laughing..ect.

In past up too today, I've never had success with girls, other aspects of life no issues. I'm at a point i no longer want to try, I just want improve my fitness goals, money, hobbies and not care about women or sex, but my friends keep pushing me to try.

So here I am, asking, how do you even gain enough confidence to approach women when you've had non stop bad experiences and you know you'll be down again when a bad thing happens again?