SQLite Regarding queries

I have created a table in SQLite database with following statement.

static final String DATABASE_CREATE =
“create table " + “TEST” +
“( " + “ID” + " integer primary key autoincrement,” +
" UID text, FULLNAME text, GENDER integer, MSTATUS integer, MOBILE text, AGE text );”;

with this statement, I can able to insert data but I want to design a function that will accept the mobile no. and return the UID.

There are better places to ask such questions, like http://stackoverflow.com/

1 Like