On 11/29/07, Jiri Hajek <[EMAIL PROTECTED]> wrote: > Hello, > > I'm considering usage of FTS, but from the documentation it's a little > unclear to me what's the recommended way of using it, particularly in > the following scenario: > > Let's say that I already have some database structure containing > several tables with mixes type of data (some string fields that I > would like to index by FTS and others that I wouldn't need to index). > How should I use FTS in this case? Create a new FTS table and store > all text data there? Would it actually be a duplication, or can FTS > store only index, without the actual full strings? >
You create a new VIRTUAL TABLE and let fts index only the fields that you want to conduct full-text search against. Your original table with its columns still remains. See <http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex> for a pretty nice explanation. If that explanation is not clear, please let us know what is confusing. I will try to make that explanation better. -- Puneet Kishor ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
