webdevwilson · February 4, 2012 19:14
diff --git a/column-priority-sql-search-1.sql b/column-priority-sql-search-1.sql
   SELECT Members.*, SEARCH_TBL.RANK AS rank
     FROM   Members INNER JOIN
           FREETEXTTABLE(Members, *, ‘breakfast’) SEARCH_TBL
               ON Members.memberID = SEARCH_TBL.[KEY]
    ORDER BY rank DESC
	SELECT Members.*, SEARCH_TBL.RANK AS rank
	FROM Members INNER JOIN
	FREETEXTTABLE(Members, *, ‘breakfast’) SEARCH_TBL
	ON Members.memberID = SEARCH_TBL.[KEY]
	ORDER BY rank DESC