title: Use variable in SQLite Query
body: <p>First of all I've looked up several topics on this but nothing specifically addressing this issue in Java. </p>
  
  <p>I have the following method.</p>
  
  <pre><code>public String getCount() {
      SQLiteDatabase db = smokinDBOpenHelper.getWritableDatabase();
      String w = "Home";
      Cursor cursor = db.rawQuery("select * from " + smokinDBOpenHelper.INCIDENTS_TABLE + 
              " where " + KEY_LOCATION + " = 'Home'", null);
  
      int i = cursor.getCount();
      String s = ("You have " + i + " entries in this column");
  
      return s;
  }
  </code></pre>
  
  <p>I would like this <code>query</code> to use the variable  above it rather than a specific hard coded <code>String</code> "Home".</p>
  
  <p>I've tried <code>+ {w}</code> <code>+ {w%}</code> <code>+ w</code> and a few others, nothing seems to work</p>