Documentation Source Text

  <i>-- Insert a row and allow FTS3 to assign a docid value using the same algorithm as</i>
  <i>-- SQLite uses for ordinary tables. In this case the new docid will be 54,</i>
  <i>-- one greater than the largest docid currently present in the table.</i>
  INSERT INTO pages(title, body) VALUES('Download', 'All SQLite source code...');

  <i>-- Change the title of the row just inserted.</i>
  UPDATE pages SET title = 'Download SQLite' WHERE rowid = last_insert_rowid();

  <i>-- Delete the entire table contents.</i>
  DELETE FROM pages;

  <i>-- The following is an error. It is not possible to assign non-NULL values to both</i>
  <i>-- the rowid and docid columns of an FTS3 table.</i>
  INSERT INTO pages(rowid, docid, title, body) VALUES(1, 2, 'A title', 'A document body');

  SELECT * FROM docs WHERE docs MATCH 'database sqlite';

  <i>-- Query for the set of documents that contains either "sqlite" or "database".</i>
  <i>-- All three documents in the database are matched by this query.</i>
  SELECT * FROM docs WHERE docs MATCH 'sqlite OR database';

  <i>-- Query for all documents that contain the term "database", but do not contain</i>
  <i>-- the term "sqlite". Document 2 is the only document that matches this criteria.</i>
  SELECT * FROM docs WHERE docs MATCH 'database NOT sqlite';

  <i>-- The following query matches no documents. Because "and" is in lowercase letters,</i>
  <i>-- it is interpreted as a basic term query instead of an operator. Operators must</i>
  <i>-- be specified using capital letters. In practice, this query will match any documents</i>
  <i>-- that contain each of the three terms "database", "and" and "sqlite" at least once.</i>
  <i>-- No documents in the example data above match this criteria.</i>