There are two search methods for SQL Server full-text retrieval, one is contains and the other is freetext. The former includes, similar to like% Keywords%;, The latter involves searching for each word after segmenting a paragraph of text.
Specific syntax:
Contains: .
SELECT field 1, field 2.
From Table Name.
Where contains (field, word one or word two).
Sort based on similarity of search results .
SELECT field 1, field 2.
From Table Name.
Inner join containerable (table name, field, word one or word two, 10) as k.
On Table Name. id= k. [key].
Order by k.RANK DESC.
Freetext: .
SELECT field 1, field 2.
From Table Name.
Where freetext (field, word one word two).
Sort based on similarity of search results .
SELECT field 1, field 2.
From Table Name.
Inner join freetexttable (table name, fields, word two, 10) as k.
On Table Name. id= k. [key].
Order by k.RANK DESC.
In the previous text, a value of 10 for freetexttable or containerable indicates taking 10 pieces of data.