Regex replace word with brackets sql?

I have similar entries in SQL datbase:

CityName (State)

How to remove (State) from here!

Values are NOT the same I mean some like this: [A-Za-z]

in MySQL, REGEXP cannot replace, only find

perhaps use POSITION() to find the left parenthesis, nested inside SUBSTRING() to capture everything up to that point

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.