create table messages(sent varchar(200), verif int); insert into messages values ('hello my name is alex', null), ('hey alin and alex I''m tom', null), ('hello alex my name is alin', null);

select * from messages;

with recursive cte as ( select substring(concat(sent, ' '), 1, locate(' ', sent)) word, substring(concat(sent, ' '), locate(' ', sent) + 1) sent from messages union all select substring(sent, 1, locate(' ', sent)) word, substring(sent, locate(' ', sent) + 1) sent from cte where locate(' ', sent) > 0 ) select row_number() over(order by count(*) desc, word) wid, word, count(*) freq from cte group by word order by wid

select * from words;