How to find the a value is existing or not in sqlite3?

Question

I am using sqlite database for android development. I should not have the repeatation of records with a same username so that i need to check is that username is existing or not in the database. For that i got a solution called count query. Can i get how to use the count query in sqlite.

Paresh Mayani · Accepted Answer · 2011-11-02 05:16:03Z

1

You can use rawQuery, something like:

final String SQL_STATEMENT = "SELECT COUNT(*) FROM users WHERE uname=?";

private void someMethod() {
    Cursor c = db.rawQuery(SQL_STATEMENT, new String[] { username });
    ...
}

answered Nov 2, 2011 at 5:16

Paresh Mayani

129k71 gold badges244 silver badges297 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to find the a value is existing or not in sqlite3?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related