re: order results by count of searched expression

On Thursday 12 December 2002 20:20, Martin Hudec wrote: > I am trying to figure out sql command for ordering results descending > by counts of searched expressions found in result. like this: > > $search="some"; > > TEXT | COUNTS | > - > Something has..| 4

order results by count of searched expression

Hello mysql, I am trying to figure out sql command for ordering results descending by counts of searched expressions found in result. like this: $search="some"; TEXT | COUNTS | - Something has..| 4| Some have..| 3| Some take..| 1|