Remove substring with parentheses in MySQL database
Posted on 2009-03-31
In a table called catalog, I have a column called SongTitle with song names...some of which contain parentheses with extra name information about the title. I need to remove info in the parentheses and the surrounding parentheses for each record. Here is an example:
Photograph (Pop Radio Edit)
I want the field to be:
Ideally, I first want to copy the whole field to another column in the catalog table called AkaSongTitle and then do the replace on the SongTitle column.
I have tried a number of combinations but can't seem to make it work. Can you please help?