select ename, group_concat(c order by c separator '')
  from (
select ename,substr(a.ename,iter.pos,1) c
  from emp a,
       ( select id pos from t10 ) iter
where iter.pos <= length(a.ename)
       ) x
gorup by ename

mysql> select ename old_name,
    ->        group_concat(c order by c separator '') new_name
    ->   from (
    -> select ename,substr(a.ename,iter.pos,1) c
    ->   from emp a,
    ->        ( select id pos from t10 ) iter
    -> where iter.pos <= length(a.ename)
    ->        ) x
    -> group by ename;
+----------+----------+
| old_name | new_name |
+----------+----------+
| ADAMS    | AADMS    |
| ALLEN    | AELLN    |
| BLAKE    | ABEKL    |
| CLARK    | ACKLR    |
| FORD     | DFOR     |
| JAMES    | AEJMS    |
| JONES    | EJNOS    |
| KING     | GIKN     |
| MARTIN   | AIMNRT   |
| MILLER   | EILLMR   |
| SCOTT    | COSTT    |
| SMITH    | HIMST    |
| TURNER   | ENRRTU   |
| WARD     | ADRW     |
+----------+----------+
14 rows in set (0.00 sec)

mysql>