Posted to tcl by jdc at Fri Apr 15 12:06:17 GMT 2011view raw
- Created FTS table like this:
- CREATE VIRTUAL TABLE pages_content_fts USING fts4(id,name,content)
- INSERT INTO pages_content_fts SELECT a.id, a.name, b.content FROM pages a, pages_content b WHERE a.id = b.id
- select id from pages_content_fts where content match 'Jos Decoster'
- select id from pages_content_fts where content match 'Jos AND Decoster'