Table table1 following structure
-
Keywords
-- -- -- -- --
Aaa
BBB, CCC
Aaa, CCC
Aaa, BBB
BBB
CCC
DDD
DDD, CCC
-- -- -- -- --

Want to get a mysql statements for check out of the results are as follows:

Col -- -- -- -- -- - num -
CCC - 4
Aaa - 3
BBB - 3
DDD -- 2




Could you tell me how to write talent? I am mysql5.2 there seems to be a functional limit a SQL best done

CodePudding user response:

Is actually want to statistical small make up into what are tag or keywords, frequency of each word

CodePudding user response:

Ask not how popular is I open in the right way

CodePudding user response:

Stored procedure using a temporary table, splitting the results into a temporary table, then from the temporary table statistics
Mysql table-valued functions, this thing is bad

CodePudding user response:

So please answer solved