Re: Boolean searches on InnoDB tables?

25/10/2007, 04h06

At 02:54 AM 3/4/2006, Daevid Vincent wrote:
>I just discovered this:
>http://dev.mysql.com/doc/refman/5.0/...t-boolean.html
>Which states:
>"They can work even without a FULLTEXT index, although a search executed in
>this fashion would be quite slow. "
>
>But then I'm kicked in the nuts because:
>http://dev.mysql.com/doc/refman/5.0/...xt-search.html
>"Full-text indexes can be used only with MyISAM tables"
>
>When I try a query on an InnoDB table:
>
>"SELECT * FROM categories WHERE MATCH (name) AGAINST ('+ELECTRONICS' IN
>BOOLEAN MODE);"
>
>I get:
>"Error Code : 1214
>The used table type doesn't support FULLTEXT indexes"
>
>So, what is the deal? Am I missing something?
>
>And if I can't use boolean searches on InnoDB tables with mySQL 5.0.18,
>Then WHEN will I be able to?
>
>In the mean time, what is the best way to generate this equivallent
>functionality via PHP or some other mySQL 5 sanctioned way? I've seen
>several different examples on the web, but don't know which to commit to.

Daevid,
Get yourself an ice-pack and visit http://www.sphinxsearch.com/.
They have a free full text search add-on for MySQL that works with InnoDb
and MyISAM tables. You'll feel better in the morning.

Mike

25/10/2007, 04h06	#1
mos Messages: n/a Hébergeur:	Re: Boolean searches on InnoDB tables? At 02:54 AM 3/4/2006, Daevid Vincent wrote: >I just discovered this: >http://dev.mysql.com/doc/refman/5.0/...t-boolean.html >Which states: >"They can work even without a FULLTEXT index, although a search executed in >this fashion would be quite slow. " > >But then I'm kicked in the nuts because: >http://dev.mysql.com/doc/refman/5.0/...xt-search.html >"Full-text indexes can be used only with MyISAM tables" > >When I try a query on an InnoDB table: > >"SELECT * FROM categories WHERE MATCH (name) AGAINST ('+ELECTRONICS' IN >BOOLEAN MODE);" > >I get: >"Error Code : 1214 >The used table type doesn't support FULLTEXT indexes" > >So, what is the deal? Am I missing something? > >And if I can't use boolean searches on InnoDB tables with mySQL 5.0.18, >Then WHEN will I be able to? > >In the mean time, what is the best way to generate this equivallent >functionality via PHP or some other mySQL 5 sanctioned way? I've seen >several different examples on the web, but don't know which to commit to. Daevid, Get yourself an ice-pack and visit http://www.sphinxsearch.com/. They have a free full text search add-on for MySQL that works with InnoDb and MyISAM tables. You'll feel better in the morning. Mike

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email