title: SQLite full-text search with multiple tokens using a prepared statement
body: <p>Given the following tables:</p>
  
  <pre><code>create table index(name text, docid int);
  create virtual table docs using fts4();
  </code></pre>
  
  <p>The following query works as intended when querying for a single token (for example: <code>march</code>, or <code>bad</code>):</p>
  
  <pre><code>select name from index where docid in (select docid from docs where docs match ?)
  </code></pre>
  
  <p>But how can I query for more than one token (say, <code>bad bed</code>)? Binding the string <code>bad bed</code> directly does not work (always selects nothing), neither surrounding the placeholder or the string with double quotes, nor using <code>AND</code> to <code>MATCH</code> each token separetly (this last one throws an error).</p>