"Ohad Eder-Pressman" <[EMAIL PROTECTED]> wrote: > i have an fts1 table populated with, errr, text. > lets say one field has this text "big monster". > > this sql query: text match 'ter' doesn't return this item. if i do a text > match 'monster' i do get this item. > > does fts1 support this behavior i need ?
No. FTS only supports full word matches, not partial word matches. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
