Как к HTML-формам стандарта тестирования

вы ищете что-то подобное?:

SELECT g.id,
    SUBSTRING_INDEX(SUBSTRING_INDEX(CONCAT(',',g.myguid,','), ',', sep.id), ',' , -1) AS newguid
FROM guid g
CROSS JOIN ( SELECT 3 AS id UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7  UNION ALL SELECT 8 UNION ALL SELECT 9 UNION ALL SELECT 10 ) AS sep
HAVING newguid != ''
ORDER BY g.id,sep.id;

выборка

MariaDB []> select * from guid;
+----+---------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | myguid                                                                                                                                                  |
+----+---------------------------------------------------------------------------------------------------------------------------------------------------------+
|  1 | #1$,{8312aeeb-3a90-4c56-b58e-e4597d2a18ac},{2a8d152b-1ea4-4a63-ae63-db011deb6dea}                                                                       |
|  2 | #1$,{8312aeeb-3a90-4c56-b58e-e4597d2aFFFF}                                                                                                              |
|  3 | #1$,{8312aeeb-AAAA-4c56-b58e-e4597d2a18ac},{BBBB-1ea4-4a63-ae63-db011deb6dea},{8312aeeb-CCCC-4c56-b58e-e4597d2a18ac},{EEEE-1ea4-4a63-ae63-db011deb6dea} |
+----+---------------------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.000 sec)

MariaDB []> SELECT g.id,
    ->     SUBSTRING_INDEX(SUBSTRING_INDEX(CONCAT(',',g.myguid,','), ',', sep.id), ',' , -1) AS newguid
    -> FROM guid g
    -> CROSS JOIN ( SELECT 3 AS id UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7  UNION ALL SELECT 8 UNION ALL SELECT 9 UNION ALL SELECT 10 ) AS sep
    -> HAVING newguid != ''
    -> ORDER BY g.id,sep.id;
+----+----------------------------------------+
| id | newguid                                |
+----+----------------------------------------+
|  1 | {8312aeeb-3a90-4c56-b58e-e4597d2a18ac} |
|  1 | {2a8d152b-1ea4-4a63-ae63-db011deb6dea} |
|  2 | {8312aeeb-3a90-4c56-b58e-e4597d2aFFFF} |
|  3 | {8312aeeb-AAAA-4c56-b58e-e4597d2a18ac} |
|  3 | {BBBB-1ea4-4a63-ae63-db011deb6dea}     |
|  3 | {8312aeeb-CCCC-4c56-b58e-e4597d2a18ac} |
|  3 | {EEEE-1ea4-4a63-ae63-db011deb6dea}     |
+----+----------------------------------------+
7 rows in set (0.001 sec)

MariaDB []>