I have a list of games and regions in my database and i messed a few up, They are missing the end bracket so most are named like Sonic The Hedgehog (E
but the letter E will change to many different regions.
How can i get rid of just the single bracket and letters ? It is always the last part of my string if that helps.
Thanks