Unconcatenate and concatenate, MySQL

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

select version() as 'mysql version';

DROP TABLE IF EXISTS hashes;
CREATE TABLE hashes (hashtag_name VARCHAR(255));
INSERT INTO hashes VALUES
    ('tido,makan,ittify,general'),
    ('ittified,general,travel,lifestyle'),
    ('makan,minum,air,tido,keyboard'),
    ('makan,minum,air,tido,lepak,gg'),
    ('nice,gg,makan,minum,keyboard'),
    ('nice,makan,tido,keyboard'),
    ('makan,makan,minum,air'),
    ('makan,makan,minum,air'),
    ('makan,makan,minum,air'),
    ('makan,makan,minum,air'),
    ('makan,makan,minum,air,tido'),
    ('makan,makan,minum,air'),
    ('makan,makan,minum,air,tido'),
    ('makan,makan,minum,air'),
    ('makan,makan,minum,tido');
     
CREATE TEMPORARY TABLE temp (val CHAR(255));
SET @S1 = CONCAT("INSERT INTO temp (val) VALUES ('",REPLACE((SELECT GROUP_CONCAT( DISTINCT hashtag_name) AS data FROM hashes), ",", "'),('"),"');");
PREPARE stmt1 FROM @s1;
EXECUTE stmt1;
SELECT group_concat(DISTINCT(val)) as hashtag_name FROM temp;


absolute service time: 0,32 sec