Thanks. I could use "*" but FTS is no gone because of not being able to use "reduce" option.
I ended up using two Queries one after the other, to perform a "search" and organize the results by another field on the documents. El viernes, 14 de febrero de 2014 19:23:16 UTC-5, Jens Alfke escribió: > > > On Feb 14, 2014, at 12:29 PM, Frederic Yesid Peña Sánchez < > [email protected] <javascript:>> wrote: > > We need to enable searching by FullTextSearch, but don't know how to do > "partial" word search, so if i have the phrase "The quick brown fox", > searching for "uic" should match. > > > The SQLite FTS docs <https://www.sqlite.org/fts3.html#section_3> say you > can do prefix matching using a "*" character, so "qui*" will match "quick". > > I don't think FTS has an option to do general substring matching, probably > because in SQL you don't need a fancy indexer to do that, it's just a > "LIKE" operation. Couchbase Lite doesn't provide a way to match using LIKE. > (And it wouldn't be very efficient even if it did, because LIKE requires a > linear scan of the index, looking at the string in every row.) > > What is it you're trying to accomplish? Matching against arbitrary > substrings seems like an unlikely use for a database. > > —Jens > -- You received this message because you are subscribed to the Google Groups "Couchbase Mobile" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/mobile-couchbase/871bb407-5aac-453e-b920-1202a127d70c%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
