Re: HELP! count*/group/ ecc....
i cannot modify existing table, im working on existing db
and i'm trying to do some statistics, if its possible...
in that database they created usertable, with column Id,User,Sports
the sports are not pre-edited... anyone can write also a not existing sport...
any user whem fill his profile can put many sports as he like, also words no existing... like 'hockey, footbal, calcio, golf, basket, baskettball, allsport, hallo to my mom'...
tha only thing i need is a sort of a search... in a full text of every row...
every row contains some words separated by a comma
i need to know which is is the word most frequent...
i hope i was clear
thanks