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/en/string-functions.html#function_substring-index
SELECT
SUBSTRING_INDEX(`A`, '0(', -1)
FROM t
Output:
3)
Can you help me?