On Feb 14, 2014, at 12:29 PM, Frederic Yesid Peña Sánchez <[email protected]<mailto:[email protected]>> 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/3D0E89DF-AEC5-4B80-9823-E0B2853A1EA4%40couchbase.com. For more options, visit https://groups.google.com/groups/opt_out.
