How do I delete a sqlite table row entry by string?

Question

I'm a noob to Android, and I am trying to figure out how to delete a table row in sqlite with by a string as opposed to a long for the row number. I have no issues adding data to my table, but when I try to delete the same value I get a SQL exception that says `SQLiteException: no such column 'my_entry': while compiling: DELETE FROM dbTABLE WHERE db_NAME = my_entry` Any insight is greatly appreciated. Here is my code: Code for adding row entry: ``` public long createEntry(String coin, String quantity, String value) { ContentValues cv = new ContentValues(); cv.put(KEY_NAME, coin); cv.put(KEY_QUANTITY, quantity); cv.put(KEY_VALUE, value); return ourDatabase.insert(DATABASE_TABLE, null, cv); } ``` Code for deleting row entry: ``` public void deleteEntry(String coin) throws SQLException{ ourDatabase.delete(DATABASE_TABLE, KEY_NAME + "=" + coin, null); } ``` Code for entire Database: ``` public static final String KEY_ROWID = "_id"; public static final String KEY_NAME = "cointype_name"; pu…

Accepted Answer

You should not use the string directly and if you do you need to wrap it in `'` since SQLite will consider it a column name otherwise.

The safest way to do it is

```
public void deleteEntry(String coin) throws SQLException{
    String[] whereArgs = new String[] { coin };
    ourDatabase.delete(DATABASE_TABLE, KEYNAME + "=?", whereArgs);
}
```

The unsafe way is

```
ourDatabase.delete(DATABASE_TABLE, KEYNAME + "='" + coin + "'", null);
```

and that will fail if `coin` contains a `'` so don't use it.

How do I delete a sqlite table row entry by string?

Solution

Problem