Relationship Problems

So my boyfriend and I were talking two days ago and I was really hurt because he told me a month ago when he was in a different country for vacation, he had texted another girl at night when he felt lonely which made me super sad and hurt because it was like you had to get another girl’s attention when you have a whole girlfriend you know? He told me he texted her for four days and stopped when he realized how wrong it was of him to do that, I couldn’t help but ask if she was prettier than me, couldn’t help but ask if she was much more fun to text and me asking these questions broke him completely, he told me that he would just text her “good morning” and “good night” and ask her how her day was, which made me feel less special and this whole idea just shattered my self esteem. He did break my trust but it’s stupid of me to say this but I do wanna give him a second chance, a second chance to prove that he can change and earn back my trust. He had a talk with his friends yesterday and his friends told me he really regrets what he did and it hurt him a lot too,what should I do?