Sorry I just read your question a bit closer, I am not sure if you can count the number of occurences using mysql, but you can certainly find out where they are. I guess you could try reading each word and creating a count manually with php, but that could get slow for a massive number of rows. Imran wrote: > > > Dear Friends, > > Is there any MySQL query that could find the most occured word in a column > of a table, without searching it? > > e.g., > > *Column Name* > - - - - - - - - - - - > John > James Bond > John > Alix > Philips > John > - - - - - - - - - - > > So, without search, we want to see that John has occured 3 times. > > Sql Query is appreciated.... if possible? > > Thanks v.much, > Imran > > [Non-text portions of this message have been removed] > >
