title: How do you match multiple column in a table with SQLite FTS3?
body: <p>Lets say I have a table with columns A , B , C , D and I want to do a match on column A and C</p>
  
  <p>I see that you can either match a single column or all column in sqlite ie</p>
  
  <pre><code>- match column A
  select * from table where A match 'cat' 
  
  - match all columns
  select * from table where table match 'cat'
  </code></pre>
  
  <p>Is it possible to match only columns A and C?  If not, how do you guys get around this?</p>
  
  <p>Thanks for your suggestion!</p>