what is the most efficient way to implement full text search on a sqlite database

I am using sqlite database for storing data. One开发者_如何学编程 of the table contains fields like name, summary, description, location etc. I want to implement full text search on this table i.e. I want to search the given word in all columns of the table. What is the best way to do this? I have a reference to sqlite.data.dll in my project.

Use SQLite FTS3 and FTS4 Extensions ? see here: SQLite FTS3 and FTS4 Extensions