Hi.

This table MySQL:
Code:
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:
Code:
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

Code:
SELECT 
SUBSTRING_INDEX(`A`, '0(', -1)
FROM t
Output:
3)

Can you help me?