Problem with function_substring-index

[Miguel61]

Hi.

This table MySQL:

A	B	C	D
0(3)	0(323)	0(970)	0(3120)
0(1)	0(62)	0(116)	0(610)
0(1)	0(3)	0(200)	0(100)
0(4)	0(148)	0(563)	0(1050)
0(1)	0(1548)	0(206)	0(2720)

I need this output:

A	B	C	D
3	323	970	3120
1	62	116	610
1	3	200	100
4	148	563	1050
1	1548	206	2720

I try use this function:
http://dev.mysql.com/doc/refman/5.0/...ubstring-index

SELECT 
SUBSTRING_INDEX(`A`, '0(', -1)
FROM t

Output:
3)

Can you help me?

[r937]

SELECT REPLACE(REPLACE(A,'0(',''),')','') AS A
     , REPLACE(REPLACE(B,'0(',''),')','') AS B
     , REPLACE(REPLACE(C,'0(',''),')','') AS C
     , REPLACE(REPLACE(D,'0(',''),')','') AS D
  FROM daTable

[Miguel61]

Thanks Sir.
I never got this solution.