MySQL Variables ft_boolean_syntax 数据库 参数变量解释及正确配置使用
本站中文解释
ft_boolean_syntax 是一个MySQL参数变量，用于定义如何解释FULLTEXT搜索时关键字之间的SET运算符，比如and、or和not运算符。要设置这个参数，可以通过以下命令：
SET GLOBAL ft_boolean_syntax = ” + -~*:\”$”;
官方英文解释
ft_boolean_syntax
| Command-Line Format | --ft-boolean-syntax=name |
|---|---|
| System Variable | ft_boolean_syntax |
| Scope | Global |
| Dynamic | Yes |
| Type | String |
| Default Value | + -><()~*:""&| |
The list of operators supported by boolean full-text searches
performed using IN BOOLEAN MODE. See
Section 12.10.2, “Boolean Full-Text Searches”.
The default variable value is
'+ -><()~*:""&|'. The rules
for changing the value are as follows:
-
Operator function is determined by position within the
string. -
The replacement value must be 14 characters.
-
Each character must be an ASCII nonalphanumeric character.
-
Either the first or second character must be a space.
-
No duplicates are permitted except the phrase quoting
operators in positions 11 and 12. These two characters are
not required to be the same, but they are the only two
that may be. -
Positions 10, 13, and 14 (which by default are set to
:,&, and
|) are reserved for future extensions.
