Server全文搜索中的通配符

Question

在查找全文搜索时，我发现了文章：

FTS区分定义为通配符的符号和其他符号。以下是FTS中用作通配符的几个符号：

+==================================+========+==============================================================================================================================================================================================================+
|            Expression            | Syntax |                                                                                                 Description                                                                                                  |
+==================================+========+==============================================================================================================================================================================================================+
| Any Character                    | .      | Matches any single character except a line break.                                                                                                                                                            |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Zero or more                     | *      | Matches zero or more occurrences of the preceding expression, making all possible matches.                                                                                                                   |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| One or more                      | +      | Matches at least one occurrence of the preceding expression.                                                                                                                                                 |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Beginning of line                | ^      | Anchors the match string to the beginning of a line                                                                                                                                                          |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| End of line                      | $      | Anchors the match string to the end of a line.                                                                                                                                                               |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Beginning of word                | < | Matches only when a word begins at this point in the text.                                                                                                                                                   |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| End of word                      | >      | Matches only when a word ends at this point in the text.                                                                                                                                                     |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Line break                       | \n     | Matches a platform-independent line break. In a Replace expression, inserts a line break.                                                                                                                    |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Any one character in the set     | [ ]    | Matches any one of the characters within the [ ]. To specify a range of characters, list the starting and ending character separated by a dash (-), as in [a-z].                                             |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Any one character not in the set | [^...] | Matches any character not in the set of characters following the ^.                                                                                                                                          |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Or                               | |      | Matches either the expression before or the one after the OR symbol (|). Mostly used within a group. For example, (sponge|mud) bath matches "sponge bath" and "mud bath."                                    |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Escape                           | \      | Matches the character that follows the backslash (\) as a literal. This allows you to find the characters used in regular expression notation, such as { and ^. For example, ^ Searches for the ^ character. |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Tagged expression                | {}     | Matches text tagged with the enclosed expression.                                                                                                                                                            |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| C/C++ Identifier                 | :i     | Matches the expression ([a-zA-Z_$][a-zA-Z0-9_$]*).                                                                                                                                                           |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Quoted string                    | :q     | Matches the expression (("[^"]*")|('[^']*')).                                                                                                                                                                |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Space or Tab                     | :b     | Matches either space or tab characters.                                                                                                                                                                      |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Integer                          | :z     | Matches the expression ([0-9]+).                                                                                                                                                                             |
+----------------------------------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

但是我找不到任何关于这种可能性和用法的信息(除了*之外)。有人能帮忙吗？

Answer 1

我怀疑所有这些符号是否得到支持。符号列表可能是从这里中提取的。但是，这会记录(SSMS)功能。

唯一受支持的符号是单词末尾的星号(*)。请参阅文档这里，在此页面中搜索。