Posted to tcl by jdc at Fri Apr 15 12:06:17 GMT 2011view raw

  1. Created FTS table like this:
  2.  
  3. CREATE VIRTUAL TABLE pages_content_fts USING fts4(id,name,content)
  4. INSERT INTO pages_content_fts SELECT a.id, a.name, b.content FROM pages a, pages_content b WHERE a.id = b.id
  5.  
  6.  
  7. select id from pages_content_fts where content match 'Jos Decoster'
  8.  
  9. select id from pages_content_fts where content match 'Jos AND Decoster'