mySQL: Get ordered list of near match items based on tag matches - Returns an ordered list of near match items based on tag matches.

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

<< last

next >>

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;