sqlite - Fts Usage

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 125,127 ****
--- 125,135 ----
  it must be written as:
  
    SELECT docid FROM recipe AS ra WHERE recipe MATCH 'stew';
+ 
+ *NOTE* that MATCH cannot be used multiple times against the same table.  So the following query, while valid syntax, will cause an error:
+ 
+   SELECT docid FROM recipe WHERE recipe MATCH 'onions' AND recipe MATCH 'cheese';
+ 
+ It must be written as:
+ 
+   SELECT docid FROM recipe WHERE recipe MATCH 'onions cheese';