How to remove certain strings from rows in MySQL

Vote count:

0

I am attempting to clean up in a messy table consisting of words which are unnecessary. The example below shows the typical content:

row1        |
-------------
text <12>   |
more [dada] |
(123) foo   |
la {55w} da |

Basically what i define as unnecessary content is all the words starting and ending with a particular symbol: <...>, [...], {...} and (...). Usually i would use the replace function, but since the data inside of the symbols are arbitrary it is not quite possible.

Is it possible to use some kind of RegEX?

asked 21 secs ago

JavaCake

751