search

jmac11 / googlecloudsql

Automatically exported from code.google.com/p/googlecloudsql
0 stars 0 forks source link

Ability to set InnoDB full-text search stop words. #98

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
It would be very nice to be able to set InnoDB full-text search stop words.

My specific use-case is to search a column of company names and display an 
auto-complete drop-down with the most relevant results first. This works very 
well using full-text search, except when part of a company name is a stop word, 
rendering the entire auto-complete functionality useless.

The only workaround I know of is to create a separate 'index table' which also 
needs to be synced with the original table. I also noticed other users (see 
https://groups.google.com/forum/#!topic/google-cloud-sql-discuss/kSJtv0Ox_-Q) 
requesting the feature.

Original issue reported on code.google.com by steenkam...@gmail.com on 22 Sep 2014 at 12:02

GoogleCodeExporter commented 9 years ago 
Sorry, I am the creator of this ticket but just saw it is a duplicate of issue 
48 (searched for stop word instead of stopword).

Original comment by steenkam...@gmail.com on 22 Sep 2014 at 12:07

GoogleCodeExporter commented 9 years ago

Original comment by rclev...@google.com on 27 Oct 2014 at 7:43