MySQL全文检索中不进行全文索引默认过滤词表(ft_stopword_file =>ft_precompiled_stopwords)

      MySQL支持全文索引和全文检索功能。 详细的MySQL全文检索的介绍请见官方手册   

       对于全文索引,MySQL会从 ft_stopword_file 变量指定的文件中读取不进行全文索引的过滤词表, 一行一个。若将该变量设置为空字符串(”)则禁用过滤词表。

 

    此变量默认为built-in,即MySQL使用自建默认过滤词表,查看MySQL4到MySQL6的源码,不同版本的默认词表是一样的,共545个,详细如下:  

 

 *ft_precompiled_stopwords[] = {

/* This particular stopword list was taken from SMART distribution
   ftp://ftp.cs.cornell.edu/pub/smart/smart.11.0.tar.Z
   it was slightly modified to my taste, though
 */

  “a’s”,
  “able”,
  “about”,
  “above”,
  “according”,
  “accordingly”,
  “across”,
  “actually”,
  “after”,
  “afterwards”,
  “again”,
  “against”,
  “ain’t”,
  “all”,
  “allow”,
  “allows”,
  “almost”,
  “alone”,
  “along”,
  “already”,
  “also”,
  “although”,
  “always”,
  “am”,
  “among”,
  “amongst”,
  “an”,
  “and”,
  “another”,
  “any”,
  “anybody”,
  “anyhow”,
  “anyone”,
  “anything”,
  “anyway”,
  “anyways”,
  “anywhere”,
  “apart”,
  “appear”,
  “appreciate”,
  “appropriate”,
  “are”,
  “aren’t”,
  “around”,
  “as”,
  “aside”,
  “ask”,
  “asking”,
  “associated”,
  “at”,
  “available”,
  “away”,
  “awfully”,
  “be”,
  “became”,
  “because”,
  “become”,
  “becomes”,
  “becoming”,
  “been”,
  “before”,
  “beforehand”,
  “behind”,
  “being”,
  “believe”,
  “below”,
  “beside”,
  “besides”,
  “best”,
  “better”,
  “between”,
  “beyond”,
  “both”,
  “brief”,
  “but”,
  “by”,
  “c’mon”,
  “c’s”,
  “came”,
  “can”,
  “can’t”,
  “cannot”,
  “cant”,
  “cause”,
  “causes”,
  “certain”,
  “certainly”,
  “changes”,
  “clearly”,
  “co”,
  “com”,
  “come”,
  “comes”,
  “concerning”,
  “consequently”,
  “consider”,
  “considering”,
  “contain”,
  “containing”,
  “contains”,
  “corresponding”,
  “could”,
  “couldn’t”,
  “course”,
  “currently”,
  “definitely”,
  “described”,
  “despite”,
  “did”,
  “didn’t”,
  “different”,
  “do”,
  “does”,
  “doesn’t”,
  “doing”,
  “don’t”,
  “done”,
  “down”,
  “downwards”,
  “during”,
  “each”,
  “edu”,
  “eg”,
  “eight”,
  “either”,
  “else”,
  “elsewhere”,
  “enough”,
  “entirely”,
  “especially”,
  “et”,
  “etc”,
  “even”,
  “ever”,
  “every”,
  “everybody”,
  “everyone”,
  “everything”,
  “everywhere”,
  “ex”,
  “exactly”,
  “example”,
  “except”,
  “far”,
  “few”,
  “fifth”,
  “first”,
  “five”,
  “followed”,
  “following”,
  “follows”,
  “for”,
  “former”,
  “formerly”,
  “forth”,
  “four”,
  “from”,
  “further”,
  “furthermore”,
  “get”,
  “gets”,
  “getting”,
  “given”,
  “gives”,
  “go”,
  “goes”,
  “going”,
  “gone”,
  “got”,
  “gotten”,
  “greetings”,
  “had”,
  “hadn’t”,
  “happens”,
  “hardly”,
  “has”,
  “hasn’t”,
  “have”,
  “haven’t”,
  “having”,
  “he”,
  “he’s”,
  “hello”,
  “help”,
  “hence”,
  “her”,
  “here”,
  “here’s”,
  “hereafter”,
  “hereby”,
  “herein”,
  “hereupon”,
  “hers”,
  “herself”,
  “hi”,
  “him”,
  “himself”,
  “his”,
  “hither”,
  “hopefully”,
  “how”,
  “howbeit”,
  “however”,
  “i’d”,
  “i’ll”,
  “i’m”,
  “i’ve”,
  “ie”,
  “if”,
  “ignored”,
  “immediate”,
  “in”,
  “inasmuch”,
  “inc”,
  “indeed”,
  “indicate”,
  “indicated”,
  “indicates”,
  “inner”,
  “insofar”,
  “instead”,
  “into”,
  “inward”,
  “is”,
  “isn’t”,
  “it”,
  “it’d”,
  “it’ll”,
  “it’s”,
  “its”,
  “itself”,
  “just”,
  “keep”,
  “keeps”,
  “kept”,
  “know”,
  “knows”,
  “known”,
  “last”,
  “lately”,
  “later”,
  “latter”,
  “latterly”,
  “least”,
  “less”,
  “lest”,
  “let”,
  “let’s”,
  “like”,
  “liked”,
  “likely”,
  “little”,
  “look”,
  “looking”,
  “looks”,
  “ltd”,
  “mainly”,
  “many”,
  “may”,
  “maybe”,
  “me”,
  “mean”,
  “meanwhile”,
  “merely”,
  “might”,
  “more”,
  “moreover”,
  “most”,
  “mostly”,
  “much”,
  “must”,
  “my”,
  “myself”,
  “name”,
  “namely”,
  “nd”,
  “near”,
  “nearly”,
  “necessary”,
  “need”,
  “needs”,
  “neither”,
  “never”,
  “nevertheless”,
  “new”,
  “next”,
  “nine”,
  “no”,
  “nobody”,
  “non”,
  “none”,
  “noone”,
  “nor”,
  “normally”,
  “not”,
  “nothing”,
  “novel”,
  “now”,
  “nowhere”,
  “obviously”,
  “of”,
  “off”,
  “often”,
  “oh”,
  “ok”,
  “okay”,
  “old”,
  “on”,
  “once”,
  “one”,
  “ones”,
  “only”,
  “onto”,
  “or”,
  “other”,
  “others”,
  “otherwise”,
  “ought”,
  “our”,
  “ours”,
  “ourselves”,
  “out”,
  “outside”,
  “over”,
  “overall”,
  “own”,
  “particular”,
  “particularly”,
  “per”,
  “perhaps”,
  “placed”,
  “please”,
  “plus”,
  “possible”,
  “presumably”,
  “probably”,
  “provides”,
  “que”,
  “quite”,
  “qv”,
  “rather”,
  “rd”,
  “re”,
  “really”,
  “reasonably”,
  “regarding”,
  “regardless”,
  “regards”,
  “relatively”,
  “respectively”,
  “right”,
  “said”,
  “same”,
  “saw”,
  “say”,
  “saying”,
  “says”,
  “second”,
  “secondly”,
  “see”,
  “seeing”,
  “seem”,
  “seemed”,
  “seeming”,
  “seems”,
  “seen”,
  “self”,
  “selves”,
  “sensible”,
  “sent”,
  “serious”,
  “seriously”,
  “seven”,
  “several”,
  “shall”,
  “she”,
  “should”,
  “shouldn’t”,
  “since”,
  “six”,
  “so”,
  “some”,
  “somebody”,
  “somehow”,
  “someone”,
  “something”,
  “sometime”,
  “sometimes”,
  “somewhat”,
  “somewhere”,
  “soon”,
  “sorry”,
  “specified”,
  “specify”,
  “specifying”,
  “still”,
  “sub”,
  “such”,
  “sup”,
  “sure”,
  “t’s”,
  “take”,
  “taken”,
  “tell”,
  “tends”,
  “th”,
  “than”,
  “thank”,
  “thanks”,
  “thanx”,
  “that”,
  “that’s”,
  “thats”,
  “the”,
  “their”,
  “theirs”,
  “them”,
  “themselves”,
  “then”,
  “thence”,
  “there”,
  “there’s”,
  “thereafter”,
  “thereby”,
  “therefore”,
  “therein”,
  “theres”,
  “thereupon”,
  “these”,
  “they”,
  “they’d”,
  “they’ll”,
  “they’re”,
  “they’ve”,
  “think”,
  “third”,
  “this”,
  “thorough”,
  “thoroughly”,
  “those”,
  “though”,
  “three”,
  “through”,
  “throughout”,
  “thru”,
  “thus”,
  “to”,
  “together”,
  “too”,
  “took”,
  “toward”,
  “towards”,
  “tried”,
  “tries”,
  “truly”,
  “try”,
  “trying”,
  “twice”,
  “two”,
  “un”,
  “under”,
  “unfortunately”,
  “unless”,
  “unlikely”,
  “until”,
  “unto”,
  “up”,
  “upon”,
  “us”,
  “use”,
  “used”,
  “useful”,
  “uses”,
  “using”,
  “usually”,
  “value”,
  “various”,
  “very”,
  “via”,
  “viz”,
  “vs”,
  “want”,
  “wants”,
  “was”,
  “wasn’t”,
  “way”,
  “we”,
  “we’d”,
  “we’ll”,
  “we’re”,
  “we’ve”,
  “welcome”,
  “well”,
  “went”,
  “were”,
  “weren’t”,
  “what”,
  “what’s”,
  “whatever”,
  “when”,
  “whence”,
  “whenever”,
  “where”,
  “where’s”,
  “whereafter”,
  “whereas”,
  “whereby”,
  “wherein”,
  “whereupon”,
  “wherever”,
  “whether”,
  “which”,
  “while”,
  “whither”,
  “who”,
  “who’s”,
  “whoever”,
  “whole”,
  “whom”,
  “whose”,
  “why”,
  “will”,
  “willing”,
  “wish”,
  “with”,
  “within”,
  “without”,
  “won’t”,
  “wonder”,
  “would”,
  “would”,
  “wouldn’t”,
  “yes”,
  “yet”,
  “you”,
  “you’d”,
  “you’ll”,
  “you’re”,
  “you’ve”,
  “your”,
  “yours”,
  “yourself”,
  “yourselves”,
  “zero”,
  NULL };

觉得文章有用?立即: 和朋友一起 共学习 共进步!

猜您喜欢

2 thoughts on “MySQL全文检索中不进行全文索引默认过滤词表(ft_stopword_file =>ft_precompiled_stopwords)

  1. Pingback: MySQL使用全文索引(fulltext index) | 喜乐从心,不应由人

发表评论

电子邮件地址不会被公开。 必填项已用 * 标注

*

您可以使用这些 HTML 标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>