How do I sort query results by keyword in a column? (SQL Server Full Text)

Question

How do I sort query results by keyword in a column? I am using SQL Server 2008 with full text indexing.

0

silent200 07 jan. '09 at 9:59

2 answers

kedar kamthe · Answer 1 · 2009-01-07T12:23:25+0000

select the column name, count (column name) as cnt from the group of tab names by column order by count (column name) desc

Ian Devlin · Answer 2 · 2009-01-07T10:16:58+0000

select * from table name by column name

Is this what you are looking for?