Dear Friends, Is there any MySQL query that could find the most occured word in a column of a table, without searching it? The word can be part of a phrase even, John1, John 2 etc. But we want to see that "John" has more number of occurences. e.g., *Column Name* - - - - - - - - - - - John 1 James Bond John 2 Alix Philips John 3 - - - - - - - - - - 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]
