title: Android SQLite select * from table where name like %key% using prepared statements
body: <p>I want to use prepared statements to prevent sql injections on Android SQLite database. However, rawquery crashes when the query  contains <code>Like</code> and works with <code>Where name = ?</code>
  is there a way to use like and prepared statements in Android SQLite db ?</p>
  
  <p>This is the query:</p>
  
  <pre><code>sqlQuery = "SELECT * FROM " + TABLE_CALLS + " where " + CALLER_NAME + " like ? COLLATE NOCASE or " + CALLER_NBR + " like ? or " + CALLER_EXT + " like ?" + " or " + IS_OUTGOING + " like ?  COLLATE NOCASE or " + TYPE + " like ? COLLATE NOCASE";
  
  Cursor cursor = database.rawQuery(sqlQuery, new String[]{"%" + criterion + "%", "%" + criterion + "%","%" + criterion + "%","%" + criterion + "%","%" + criterion + "%"});
  </code></pre>
  
  <p>it gives a bind or column index out of range
  Thank you.</p>