MySQL 5.7 後，InnoDB 也支援 FULLTEXT Search 了。
- 詳見：13.9 Full-Text Search Functions
- Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns.
- Full-text indexes 只能用在 InnoDB / MyISAM，欄位格式支援：CHAR、VARCHAR、TEXT
InnoDB 和 MyISAM 在系統內建的停用字清單分別是哪些字？如何指定自己的停用字清單？
MySQL InnoDB / MyISAM 預設的英文停用字清單
InnoDB 的停用字清單 與 自己設定的方法
- InnoDB 預設的 Stop words 可見：22.31.22 The INFORMATIONSCHEMA INNODBFTDEFAULTSTOPWORD Table
- mysql> SELECT * FROM INFORMATIONSCHEMA.INNODBFTDEFAULTSTOPWORD;
- a
- about
- an
- are
- as
- at
- be
- by
- com
- de
- en
- for
- from
- how
- i
- in
- is
- it
- la
- of
- on
- or
- that
- the
- this
- to
- was
- what
- when
- where
- who
- will
- with
- und
- the
- www
InnoDB 想要自己指定 Stop words 可見：15.12 InnoDB Startup Options and System Variables --innodbftserverstopwordtable=dbname/tablename
InnoDB 建立自己的停用字 Table 步驟
- 下述摘錄自此篇：13.9.4 Full-Text Stopwords
- mysql> use test
- mysql> CREATE TABLE mystopwords(value VARCHAR(30)) ENGINE = INNODB;
-- Insert stopwords (for simplicity, a single stopword is used in this example) - mysql> INSERT INTO mystopwords(value) VALUES ('Ishmael');
- mysql> SET GLOBAL innodbftserverstopwordtable = 'test/mystopwords';
-- CREATE FULLTEXT INDEX idx ON tablename(colnum_name);
MyISAM 的停用字清單 與 自己設定的方法
- MyISAM 的 Stop words (storage/myisam/ft_static.c)
- 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
- known
- knows
- 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
- wouldn't
- yes
- yet
- you
- you'd
- you'll
- you're
- you've
- your
- yours
- yourself
- yourselves
- zero
MyISAM 想要另外指定 stop word file 可見：6.1.4 Server System Variables --ftstopwordfile=file_name