Re: Fast relevance sorting of full text search results

2008-01-09 Thread Sebastian Mendel
Urms schrieb: > I'm using pretty standard approach to sorting search results by relevancy: > > SELECT DISTINCT product_name, > MATCH (keywords) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN MODE) AS > rate > FROM _TT > WHERE MATCH ( keywords ) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN

Re: Fast relevance sorting of full text search results

2008-01-06 Thread Shawn Green
Urms wrote: I'm using pretty standard approach to sorting search results by relevancy: SELECT DISTINCT product_name, MATCH (keywords) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN MODE) AS rate FROM _TT WHERE MATCH ( keywords ) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN MODE ) >0 OR