compare sqlite with string

Question

I saved Data in my SQL databank.

Now I want to compare this saved data, with a string

Something like this:

String example = "house";

Now I want to check, if "house" is already in the databank, with a if clause

something like this

if ( example == [SQL Data] ) {
}
else {
}

Now, how can I accomplish this ?

Answer 1

Do something like

String sql = "SELECT * FROM your_table WHERE your_column = '" + example + "'";
Cursor data = database.rawQuery(sql, null);

if (cursor.moveToFirst()) {
// record exists
} else {
// record not found
}

stolen from here

Answer 2

Writing my reply to Sharath's comment as an answer, as the code will be messed up in a comment:

Not saying your reply is wrong, but it's really inefficient to select everything from the table and iterate over it outside the database and it shouldn't be suggested as an answer to the question, because it's a bad habbit to do like that in general.

The way I usually do it, if I want to see if some record is present in the database, I do like this. Not gonna argue about using do-while over a normal while-loop, because that's about different preferences ;)

String query = "SELECT * FROM table_name WHERE column_name=" + the_example_string_to_find;              
Cursor cursor = db.rawQuery(query, null);

if(cursor.getCount() > 0) {
    cursor.moveToFirst();
    while(!cursor.isAfterLast()) {
        // Do whatever you like with the result.
        cursor.moveToNext();
    }
}