column priority sql search #2

column-priority-sql-search-2

SELECT Members.*,
           NAME_SRCH.RANK AS rank1, SRCH.RANK AS rank2
    FROM   Members LEFT OUTER JOIN
      FREETEXTTABLE(Members, name, ‘breakfast’) NAME_SRCH ON
        Members.memberID = NAME_SRCH.[KEY] LEFT OUTER JOIN
      FREETEXTTABLE(Members, *, ‘breakfast’) SRCH ON
        Members.memberID = SRCH.[KEY]
   ORDER BY rank1 DESC, rank2 DESC