title: Android Sqlite select Query if value is zero or 0
body: <p>I am trying to program a get a query that will show data from COURSE table if the values are :</p>
  
  <pre><code>course_id=0
  or
  semester_id=0
  or
  level_id=0
  or
  level_code=Select level
  or
  grade=Grade
  </code></pre>
  
  <p>So any rows that have any of the values above should be showed :</p>
  
  <pre><code>public List&lt;Courses&gt; getListCourseError() {
      Courses courses = null;
      List&lt;Courses&gt; coursesList = new ArrayList&lt;&gt;();
      openDatabase();
      Cursor cursor = mDatabase.rawQuery("SELECT * FROM COURSES WHERE semester_id=0 OR level_id=0 OR level_code=Select level OR grade=Grade", null);
      cursor.moveToFirst();
      while (!cursor.isAfterLast()) {
          courses = new Courses(cursor.getInt(0), cursor.getInt(1), cursor.getString(2), cursor.getInt(3), cursor.getInt(4), cursor.getString(5), cursor.getInt(6), cursor.getString(7), cursor.getInt(8), cursor.getInt(9));
          coursesList.add(courses);
          cursor.moveToNext();
      }
      cursor.close();
      closeDatabase();
      return coursesList;
  }
  </code></pre>
  
  <p>Thanks</p>