title: Retrieving specific data based on ID from SQLite in ANDROID
body: <p>I wrote a code in which i can retrieve the data from the database but when i run it and try to search something. The application crashes as soon as i press Submit</p>
  
  <pre><code>public class search extends AppCompatActivity {
      Button SearchButton;
      EditText SearchText;
      TextView SearchResult;
      SQLiteDatabase db;
      String builder;
      @Override
      public void onCreate(Bundle savedInstanceState) {
          super.onCreate(savedInstanceState);
          setContentView(R.layout.search);
          SearchButton=(Button)findViewById(R.id.searchbutton);
          SearchText=(EditText)findViewById(R.id.Searchtext);
          SearchResult=(TextView)findViewById(R.id.SearchCourse);
          db=this.openOrCreateDatabase("Courses", Context.MODE_PRIVATE,null);
  
          SearchButton.setOnClickListener(new View.OnClickListener() {
              @Override
              public void onClick(View v) {
                  int GetID = Integer.valueOf(SearchText.getText().toString());
                  Cursor TuplePointer = db.rawQuery("Select from Course where ID="+GetID+"",null);
  
                  TuplePointer.moveToFirst();
                  String Course = TuplePointer.getString(TuplePointer.getColumnIndex("Course"));
                  SearchResult.setText(Course);
              }
          });
  
      }
  }
  </code></pre>