title: sqlite3 query Android
body: <p>I'm relatively to SQLite3 so I want to make a query that makes a multi-word search, I've tried using Match Against to make a full text search, as it can be done in MySQL, but it didn't work since SQLite3 doesn't support this type of queries. so I would like to know how can this be done, and also if SQLite3 have some especial commands to make more complex queries. any help would be greatly appreciated.</p>
  
  <p>I've looked for a while into SQLite documentation but no luck :(</p>
  
  <pre><code>SELECT product,category FROM products 
  WHERE MATCH(product,category) AGAINST ('text')
  </code></pre>