cron Guest
| Posted: 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 |
|