order search results by frequency?

 
   Computer Help Archives Forum Index -> MySQL
View previous topic :: View next topic  
AuthorMessage
cron
Guest





PostPosted: Fri Nov 17, 2006 12:56 pm    Post subject: order search results by frequency?

Hi is it possible to order a mySQL statement which uses "WHERE haystack
LIKE '%needle%'" based on the number of times the 'needle' is found in
the 'haystack'?

This would be very handy for search engine results etc to put the most
relevent topics at the top of the results list.

Cheers,
Ciarán
Back to top
Display posts from previous:   
   Computer Help Archives Forum Index -> MySQLAll times are GMT - 5 Hours
Page 1 of 1

 
Jump to: