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.