title: How do I match on three values / keywords in a full text search?
body: <p>I am using a query similar to the one below:</p>
  
  <pre><code>SELECT id, description 
  FROM FullTextTable
  WHERE FullTextTable MATCH '1.010 OR 1.01 OR 1.0100'
  </code></pre>
  
  <p>If I only use two 'OR' operators, the query returns as expected, but I get no results when I attempt to use three or more 'OR' operators. How would you phrase a query to check for any of three or more values?</p>
  
  <p>This is using the Sqlite FTS4 standard full text query syntax, which I believe does not support changing the order of operations with the use of parenthesis.</p>
  
  <p>I have descriptions which contain decimals values at an arbitrary precision level and our users will not necessarily search at the same precision level as what is stored in the descriptions (e.g. a user may want to search for 1.010, but the description is actually worded as 1.01 or 1.0100 and the user won't know this ahead of time).</p>