MYSQL query to perform work count

[mpilman]

The following oracle query purports to output a word count for all words found in a table column. Is this possible in MYSQL?

Mike

=============== =============== =============== ======
Measuring of word frequency in text data SQL query:

select Word, count(*) Frequency
from
(
select substr(text, instr(' '||text, ' ', 1, n),
instr(' '||text||' ', ' ', 1, n+1)-instr(' '||text, ' ', 1, n)-1) Word
from
(
select translate(lower (comments),
',.!?:;''"()[]{}<>-+=*/\$#%&^@|'||chr( 9)||chr(10),
' ') text
from all_tab_comment s
where owner = 'SYS'
and comments is not null
), rowset
where nvl(instr(' '||text||' ', ' ', 1, n+1), 0) > 0
and instr(' '||text||' ', ' ', 1, n+1)-instr(' '||text, ' ', 1, n)-1 > 0
and n < 40
)
group by word
order by 2 DESC