[b]原型: translate(<string>,<old_chars>,<new_chars>)[/b]
示例:
1.select translate('2031758649-0123456789','0124','abcd') from fual;
回传:ca3b7586d9-abc3d56789
2. select translate('2031758649-0123456789','0124','abcd') from fual;
回传:cab758649-abc456789
3.select translate('2031758649-0123456789','012','abcd') from fual;
回传:ca3b758649-abc3456789
4.select translate('2031758649-0123456789','01234','a') from fual;
回传:a75869-a56789
[b]总结:从old_chars 到new_chars,从头开始 一一对应 ,没有对应值的则对应“空”,即什么都没有。[/b]
示例:
1.select translate('2031758649-0123456789','0124','abcd') from fual;
回传:ca3b7586d9-abc3d56789
2. select translate('2031758649-0123456789','0124','abcd') from fual;
回传:cab758649-abc456789
3.select translate('2031758649-0123456789','012','abcd') from fual;
回传:ca3b758649-abc3456789
4.select translate('2031758649-0123456789','01234','a') from fual;
回传:a75869-a56789
[b]总结:从old_chars 到new_chars,从头开始 一一对应 ,没有对应值的则对应“空”,即什么都没有。[/b]