Wildcards don't work in the replace function like that, unfortunately. What you can do is use the CONCAT(), LEFT(), RIGHT(), and INSTR() functions to get to the left and right parentheses:
mysql> SET @string = 'I am (not) confused';
Query OK, 0 rows affected (0.20 sec)
mysql> SELECT CONCAT(LEFT(@string, INSTR(@string, '(') -1), RIGHT(@string, LENGTH(@string) - INSTR(@string, ')')-1));
+--------------------------------------------------------------------------------------------------------+
| CONCAT(LEFT(@string, INSTR(@string, '(') -1), RIGHT(@string, LENGTH(@string) - INSTR(@string, ')')-1)) |
+--------------------------------------------------------------------------------------------------------+
| I am confused |
+--------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com