Regex replace word with brackets sql?

Databases
1

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]

2

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

3

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