title: sqlite LIKE function doesnt works with comma?
body: <p>I am wondering, my codes run but it doesn't return results as what I want. For example the data on my </p>
  
  <blockquote>
    <p>column1 is : hotdog,bacon,cheese</p>
  </blockquote>
  
  <p>and I want to search bacon. like query cant find bacon. but if I searched cheese or hotdog like query can find it. I think if the word surrounds with a comma. What do I need to do? </p>
  
  <pre><code>public ArrayList&lt;String&gt; getrecom(int recom1) {
      ArrayList&lt;String&gt; result = new ArrayList&lt;String&gt;();
  
      SQLiteDatabase db = dbHelperFoods.getWritableDatabase();
      String selectQuery = "SELECT * FROM "+ recom.TABLE+" WHERE " +KEY_recom+ " LIKE '%"+recom1+"%'";
      Cursor cursor = db.rawQuery(selectQuery, null);
      if (cursor.moveToFirst()) {
          result.add(cursor.getString(cursor.getColumnIndex("name")));
          while (cursor.moveToNext()) {
              result.add(cursor.getString(cursor.getColumnIndex("name")));
          }
      }
      cursor.close();
      db.close();
      return result;
  }
  </code></pre>