Particletree » Ranked Searches with SQL - The Diigo Meta page

• 12 Aug 08
  

  Hector Carcedo

  webdev sql tips rank search

• 29 Feb 08
  

  Tristan Bailey

  SELECT SUM(((LENGTH(Body) - LENGTH(REPLACE(Body, 'term', '')))/4) + ((LENGTH(Body) - LENGTH(REPLACE(Body, 'search', '')))/6)) AS Occurrences FROM Posts GROUP BY PostId ORDER BY Occurrences DESC

  sql search mysql database

• 06 Jan 08
  

  Tor Bjornrud

  mysql lamp deliciousImport

• 26 Nov 07
  

  database sql

• 20 Nov 07
  

  henrique matias

  algorithm database dev mysql sql search fulltext webdev php programming howto

• 02 Nov 07
  

  Martin S.

  sql

• 27 Oct 07
  

  Myles A Braithwaite

  database dev fulltext howto optimization mysql php programming rank search sql web-development webdesign webdev work

• 26 Oct 07
  

  jason clark

  programming mysql search howto

• 

  Bob Carr

  sql

• 25 Oct 07
  

  inaki ecenarro

  Cómo ordenar los resultados de una query MySQL por relevancia (número de veces que se repite la query) sin tener que utilizar fulltext

  sarelinks mysql

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.