Quick Search:
 
 mySQL: Get ordered list of near match items based on tag matches Jump to:  
Category: >> mySQL >> Get ordered list of near match items based on tag matches  

<< lastnext >>

Snippet Name: Get ordered list of near match items based on tag matches

Description: Returns an ordered list of near match items based on tag matches.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

SELECT t2.dbid, t2.tag, COUNT(t2.dbid) AS match_count 
FROM tags AS t1, tags AS t2 
WHERE t1.dbid = '105319' 
AND t2.tag = t1.tag AND t1.dbid != t2.dbid 
GROUP BY t2.dbid 1 
ORDER BY match_count;


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org