我想使用全文索引实现%xxx%的功能,但是我在全文索引里面只看到有xxx*,也就是说如果xxx不是起始位置的话,是无法查询到想要的结果的,不知道全文索引是否有这样的功能。实验:
SELECT * FROM zzzz WHERE NAME LIKE '%mi%'; -- 可以查到270条记录SELECT * FROM zzzz WHERE MATCH(NAME) AGAINST('mi' IN BOOLEAN MODE) -- 两条记录SELECT * FROM zzzz WHERE MATCH(NAME) AGAINST('mi*' IN BOOLEAN MODE) -- 150行记录所有270行字段内容:name
Ai Mini
Atomic Kitten
Demi Lovato
Michael Bolton
Michael孙
Miley Cyrus
Mimo
Mini
Mirai未来
Misster
MiYa
Nicki Minaj
2 Unlimited
Bette Midler
Camila
Chamillionaire
Chrisette Michele
Christina Milian
Emilia
EMILY OSMENT
Eminem
Fat Domino
Fort Minor
Gabriella Cilmi
George MichaeL
Jamie Foxx
Jazmine Sullivan
Jeremih
Joanna Smith
Katie Armiger
Kylie Minogue
Michael Buble
Michael Franti
Michael Jackson
Michael learns to rock
MICHAEL PRICE
Michelle Branch
Mickey Factz
Middle of the road
Miguel
Mika
Mike Posner
Mindless Behavior
Mindy Smith
MINI VIVA
Miranda Cosgrove
Miss Higgins
Missy Higgins
My Chemical Romance
Semisonic
Will Smith
Willow Smith
Yasmin
4 Minute
Chemistry
hitomi
Hitomiちゃん
JUNGLE SMILE
Katsumi
Masumi
Mick Bronsnan
Mihimaru Gt
MIJU
Mi-Ke
Mink
MINMI
Misia
Mitsuo
Miwa
Namiko
Nomico
Thee Michelle Gun Elephant
Camilla
Dream Family
Honey Family
Limit
Mighty Mouth
Mis=Mr
Miss A
Mix
Miz
Y.G Family(Yanggoon)
A Domino
Aerosmith
Ami(아미)
Chemistry Supported By Monkey Majik
Chubu End Satomi
COMING CENTURY
Damian Marley
Dynamics
Elliott Yamin
Emili Sande
Emilia Fox
Emilia With Basara Nekki
Glenn Miller
High And Mighty Color
Hiromi
Jasmine
Jean Michel Jarre
Kuming
Little Screaming Revue
M.Family
Malice Mizer
Mami
Mayumi
Miami Sound Machine
Michael
Micky Issaree Thongthammaroj
Micro Of Def Tech
Mie
Mieko
MiHo
Mike
Milestone
Miley Climb
Minako With Wild Cats
Minnie Riperton
Minoru
Mio
Mirror Mirror
Mis Teep
Misono
Missing Link
Miwa Yoshida
Mix 2
Miyuki
Ms Dynamite
namolla family
Nana Staring Mika Nakashima
Naomi
Natsumi
P.Domingo
Primax Mix
Rainstone Remix
Smileage
Sala With Milestone
Sammie
Satomi`
Smile
Smith
Steve Miller Band
Suemitsu
Sunmin
Takamichi
Tamamizu
The Herman S Hermits
The Michelle Gun Elephant
Theadministration
Vitamin C
Yumie
雅-Miyavi-
Mib三重唱
Micro…
Armin Van Buuren
Michelle Williams
Tonya Mitchell
Emily
Lea Michele
Smile.G
Miumiu
Echosmith
Sam Smith
Little Mix
MastaMic
Mike Chang
Mix-2
Mi2
Dami Im
Earthmind
Fumika
Ingrid Michaelson
Jamie Cullum
Jamie Grace
Jamie Lynn Spears
Jesus Fashion Family
K.Michelle
Karmin
Kate Miller
MIC
MIC男团
Midlake
Mike Candys
Mike Hough
Mikky Ekko
Mila J
Milky Chance
Miriam Bryant
Molly Smitten
Mr.Miss
Oliver&jimi jules
Petit Milady
Pia Mia
Sage The Gemini
Salaam Remi
みみめめMIMI
Sunmi
Miki
koumis蓓丽
Amine
An Young Min
Ánh Minh
Ayami
Big Audio Dynamite
Breaking Benjamin
Corey Smith
Del Amitri
DJ Miller
Funior Miles
Gemini
Granger Smith
Humming Urban Stereo
Jamie XX
Jamiroquai
JASMINE V
Jeremiah
J-Min
KangNam(MIB)
Lighthouse Family
Lumidee
M.W.Smith
Mac Miller
MI
Michael Kiwanuka
Michael McDonald
Michal
Michala Todd
Micheal W.Smith
Michel Telo
MiChi
Michie One
Mick Jones
Mickey 3 d
Mickey Oliver F.
Micro
Mie
MIIII
Mik
Mike Jones
Mike Reno
Milky Bunny
Milow
Mina
Minh Tuyết
MiRai
Miranda Lambert
Misha B
Miss $
Missy Elliot
Mis-Teeq
Misty Eyes
Mixion
Mizz Nina
Mr. Mister
Ms. Dynamite
NAMIGIRL
Park Seong Min
Rhythmic
Roger Miller
Roomie
SIMS(MIB)
Sinsemilia
Smile Queen
Tamia
The Little Monsters Family
The Lumineers
Two-Mix
Yuming
omi
Michael Wong
Jasmine Thompson请高手指教。谢谢
SELECT * FROM zzzz WHERE NAME LIKE '%mi%'; -- 可以查到270条记录SELECT * FROM zzzz WHERE MATCH(NAME) AGAINST('mi' IN BOOLEAN MODE) -- 两条记录SELECT * FROM zzzz WHERE MATCH(NAME) AGAINST('mi*' IN BOOLEAN MODE) -- 150行记录所有270行字段内容:name
Ai Mini
Atomic Kitten
Demi Lovato
Michael Bolton
Michael孙
Miley Cyrus
Mimo
Mini
Mirai未来
Misster
MiYa
Nicki Minaj
2 Unlimited
Bette Midler
Camila
Chamillionaire
Chrisette Michele
Christina Milian
Emilia
EMILY OSMENT
Eminem
Fat Domino
Fort Minor
Gabriella Cilmi
George MichaeL
Jamie Foxx
Jazmine Sullivan
Jeremih
Joanna Smith
Katie Armiger
Kylie Minogue
Michael Buble
Michael Franti
Michael Jackson
Michael learns to rock
MICHAEL PRICE
Michelle Branch
Mickey Factz
Middle of the road
Miguel
Mika
Mike Posner
Mindless Behavior
Mindy Smith
MINI VIVA
Miranda Cosgrove
Miss Higgins
Missy Higgins
My Chemical Romance
Semisonic
Will Smith
Willow Smith
Yasmin
4 Minute
Chemistry
hitomi
Hitomiちゃん
JUNGLE SMILE
Katsumi
Masumi
Mick Bronsnan
Mihimaru Gt
MIJU
Mi-Ke
Mink
MINMI
Misia
Mitsuo
Miwa
Namiko
Nomico
Thee Michelle Gun Elephant
Camilla
Dream Family
Honey Family
Limit
Mighty Mouth
Mis=Mr
Miss A
Mix
Miz
Y.G Family(Yanggoon)
A Domino
Aerosmith
Ami(아미)
Chemistry Supported By Monkey Majik
Chubu End Satomi
COMING CENTURY
Damian Marley
Dynamics
Elliott Yamin
Emili Sande
Emilia Fox
Emilia With Basara Nekki
Glenn Miller
High And Mighty Color
Hiromi
Jasmine
Jean Michel Jarre
Kuming
Little Screaming Revue
M.Family
Malice Mizer
Mami
Mayumi
Miami Sound Machine
Michael
Micky Issaree Thongthammaroj
Micro Of Def Tech
Mie
Mieko
MiHo
Mike
Milestone
Miley Climb
Minako With Wild Cats
Minnie Riperton
Minoru
Mio
Mirror Mirror
Mis Teep
Misono
Missing Link
Miwa Yoshida
Mix 2
Miyuki
Ms Dynamite
namolla family
Nana Staring Mika Nakashima
Naomi
Natsumi
P.Domingo
Primax Mix
Rainstone Remix
Smileage
Sala With Milestone
Sammie
Satomi`
Smile
Smith
Steve Miller Band
Suemitsu
Sunmin
Takamichi
Tamamizu
The Herman S Hermits
The Michelle Gun Elephant
Theadministration
Vitamin C
Yumie
雅-Miyavi-
Mib三重唱
Micro…
Armin Van Buuren
Michelle Williams
Tonya Mitchell
Emily
Lea Michele
Smile.G
Miumiu
Echosmith
Sam Smith
Little Mix
MastaMic
Mike Chang
Mix-2
Mi2
Dami Im
Earthmind
Fumika
Ingrid Michaelson
Jamie Cullum
Jamie Grace
Jamie Lynn Spears
Jesus Fashion Family
K.Michelle
Karmin
Kate Miller
MIC
MIC男团
Midlake
Mike Candys
Mike Hough
Mikky Ekko
Mila J
Milky Chance
Miriam Bryant
Molly Smitten
Mr.Miss
Oliver&jimi jules
Petit Milady
Pia Mia
Sage The Gemini
Salaam Remi
みみめめMIMI
Sunmi
Miki
koumis蓓丽
Amine
An Young Min
Ánh Minh
Ayami
Big Audio Dynamite
Breaking Benjamin
Corey Smith
Del Amitri
DJ Miller
Funior Miles
Gemini
Granger Smith
Humming Urban Stereo
Jamie XX
Jamiroquai
JASMINE V
Jeremiah
J-Min
KangNam(MIB)
Lighthouse Family
Lumidee
M.W.Smith
Mac Miller
MI
Michael Kiwanuka
Michael McDonald
Michal
Michala Todd
Micheal W.Smith
Michel Telo
MiChi
Michie One
Mick Jones
Mickey 3 d
Mickey Oliver F.
Micro
Mie
MIIII
Mik
Mike Jones
Mike Reno
Milky Bunny
Milow
Mina
Minh Tuyết
MiRai
Miranda Lambert
Misha B
Miss $
Missy Elliot
Mis-Teeq
Misty Eyes
Mixion
Mizz Nina
Mr. Mister
Ms. Dynamite
NAMIGIRL
Park Seong Min
Rhythmic
Roger Miller
Roomie
SIMS(MIB)
Sinsemilia
Smile Queen
Tamia
The Little Monsters Family
The Lumineers
Two-Mix
Yuming
omi
Michael Wong
Jasmine Thompson请高手指教。谢谢
Micheal W.Smith
Jean Michel Jarre
Michel Telo
Chrisette Michele
Lea Michele
Michelle Branch
Thee Michelle Gun Elephant
The Michelle Gun Elephant
Michelle Williams
K.Michelle
MiChi
Michie One
Mick Bronsnan
Mick Jones
Mickey Factz
Mickey 3 d
Mickey Oliver F.
Micky Issaree Thongthammaroj
Micro Of Def Tech
Micro…
Micro
MIC男团
Middle of the road
Midlake
Bette Midler
Mie
Mie
Mieko
Mighty Mouth
High And Mighty Color这类词是检索不到:
Camilla
Dream Family
Honey Family
Limit
Y.G Family(Yanggoon)
A Domino
Aerosmith
Ami(아미)
Chemistry Supported By Monkey Majik
Chubu End Satomi
COMING CENTURY
Damian Marley
Dynamics
Elliott Yamin
Emili Sande
Emilia Fox
Emilia With Basara Nekki
Hiromi
Jasmine
Kuming
Little Screaming Revue
M.Family
Mami
Mayumi
Ms Dynamite
namolla family
Naomi
Natsumi
P.Domingo
Rainstone Remix
Smileage
Sammie
Satomi`
Smile
Smith
Suemitsu
Sunmin
Takamichi也就是说首词是mi的就可以检索到,不是首词的就检索不到。难道没有办法检索到不是首词的数据吗?