MariaDB [sandbox]> drop table if exists t;

Query OK, 0 rows affected (0.14 sec)

MariaDB [sandbox]>

MariaDB [sandbox]> create table t(id int, name varchar(10), breadcrumbs varchar(100));

Query OK, 0 rows affected (0.18 sec)

MariaDB [sandbox]> insert into t values

-> ( 1 , 'test' , '01' ),

-> ( 5 , '-d' , '01,05' ),

-> ( 4 , 'c' , '04' ),

-> ( 6 , 'e' , '06' ),

-> ( 2 , '-a' , '06,02' ),

-> ( 3 , '--b' , '06,02,03');

Query OK, 6 rows affected (0.01 sec)

Records: 6 Duplicates: 0 Warnings: 0

MariaDB [sandbox]>

MariaDB [sandbox]> drop table if exists t1;

Query OK, 0 rows affected (0.13 sec)

MariaDB [sandbox]> create table t1 as

-> select

-> @i:[email protected]+1 id,

-> t.name,t.breadcrumbs

-> from (select @i:=0) i,

-> t

-> order by breadcrumbs;

Query OK, 6 rows affected (0.22 sec)

Records: 6 Duplicates: 0 Warnings: 0

MariaDB [sandbox]>

MariaDB [sandbox]> select * from t1;

+------+------+-------------+

| id | name | breadcrumbs |

+------+------+-------------+

| 1 | test | 01 |

| 2 | -d | 01,05 |

| 3 | c | 04 |

| 4 | e | 06 |

| 5 | -a | 06,02 |

| 6 | --b | 06,02,03 |

+------+------+-------------+

6 rows in set (0.00 sec)