Using pivot table in MySQL

mysql> desc common_pivot
   -> ;
+--------+----------+------+-----+---------+----------------+
| Field  | Type    | Null | Key | Default | Extra          |
+--------+----------+------+-----+---------+----------------+
| seq_id | int(11)  | NO  | PRI | NULL    | auto_increment |
| seq_nm | char(32) | YES  |    | NULL    |                |
+--------+----------+------+-----+---------+----------------+

select
reverse(substring(reverse(substring(concat(a.seperator,a.param,a.seperator),1,b.seq_id)),1,instr(reverse(substring(concat(a.seperator,a.param,a.seperator),1,b.seq_id)),a.seperator)-1)) as generated_str
from (
       select
           'ab,bc,cd,de,ef,fg,gh,hi' as param,
           ',' as seperator
       from common_pivot where seq_id=1
) a cross join common_pivot b
where b.seq_id<=length(a.param)+length(a.seperator)
and substring(concat(a.param,a.seperator),b.seq_id,1) = a.seperator;

select substring(concat(a.seperator,a.param,a.seperator),1,b.seq_id),
      reverse(substring(concat(a.seperator,a.param,a.seperator),1,b.seq_id)),
   reverse(substring(reverse(substring(concat(a.seperator,a.param,a.seperator),1,b.seq_id)),1,instr(reverse(substring(concat(a.seperator,a.param,a.seperator),1,b.seq_id)),a.seperator)-1)) as generated_str
from (
       select
           'ab,bc,cd,de,ef,fg,gh,hi' as param,
           ',' as seperator
       from common_pivot where seq_id=1
) a cross join common_pivot b
where b.seq_id<=length(a.param)+length(a.seperator)
and substring(concat(a.param,a.seperator),b.seq_id,1) = a.seperator;