SO 47415005, 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 t\\
drop table if exists temp\\
drop function if exists SPLIT_STR\\
drop procedure if exists ABC\\

create table t(id int, name text)\\
create table temp(str varchar(10));

insert into t values(1,'aaa,bbb')\\
insert into t values(1,'ccc,ddd,aaa')\\
insert into t values(3,'eee,aaa,ccc')\\
insert into t values(4,'ddd')\\

CREATE PROCEDURE ABC(IN fullstr varchar(1000))
   BEGIN
      DECLARE a INT Default 0;
      DECLARE str VARCHAR(255);
      simple_loop: LOOP
         SET a=a+1;
         SET str=SPLIT_STR(fullstr,",",a);         
         IF str='' THEN
            LEAVE simple_loop;       
         END IF;        
         #Do Inserts into temp table here with str going into the row
         insert into t1 values (str);
   END LOOP simple_loop;
   END \\

CREATE FUNCTION SPLIT_STR(
  x VARCHAR(255),
  delim VARCHAR(12),
  pos INT
)
RETURNS VARCHAR(255)
RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos),
       LENGTH(SUBSTRING_INDEX(x, delim, pos -1)) + 1),
       delim, '')\\

select @str:= group_concat(name separator ',') from t;

call abc(@str);
         
select *from t1;

select
str as word,
count(*) as occurence   
from temp
group by str;


absolute service time: 0,37 sec