I tried to create an android app that gets data from server save it for later use when there is no connectivity and use it to perform calculations later. I am getting data from server and able to save it as well but not able get specific data with sqlitedatabase.rawquery("select cons_name from "+DATABASE_TABLE+" where cons_name="+name,null) here name is string value that I am getting as a reference from edittext. Please help or guide me to get specific data from database using distinct option query not rawquery option.

thank you