SQLite Full-Text Search - The journey with little green menSQLite contains full-text search module called FTS3, using this module you can easily add fast full text search to an Android application. First you need to create virtual table: CREATE VIRTUAL TABLE TableName USING FTS3(ColOne TEXT, ColTwo DATETIME) Your table must contains at least 1 TEXT field. The FTS3 virtual table acts like a regular table, but you need to manually maintain the indexes to ke
