중간에 '000' 있는 바람에..
뒤에서부터 차례로 '000'을 없애는 코드
잘 활용하시길..^^;
뒤에서부터 차례로 '000'을 없애는 코드
잘 활용하시길..^^;
set @a = '001010001000000';
select
if( right(@a,12) = '000000000000', substring(@a, 1, 3),
if( right(@a, 9) = '000000000', substring(@a, 1, 6),
if(right(@a, 6) = '000000', substring(@a, 1, 9),
if(right(@a, 3) = '000', substring(@a, 1, 12), @a)
)
)
) as code
select
if( right(@a,12) = '000000000000', substring(@a, 1, 3),
if( right(@a, 9) = '000000000', substring(@a, 1, 6),
if(right(@a, 6) = '000000', substring(@a, 1, 9),
if(right(@a, 3) = '000', substring(@a, 1, 12), @a)
)
)
) as code
