带有WHERe子句的UNIOn-Android Eclipse

未使用的参数的值为NULL。只有

comm_acc

您必须为查询提供六个参数：

String searchPattern = searchText.getText().toString() + "%";cursor = db.rawQuery("SELECT ... ? ... ? ... ? ... ? ... ? ... ? ...",          new String[]{ searchPattern, searchPattern, searchPattern,  searchPattern, searchPattern, searchPattern });

或在所有LIKE中使用相同的参数：

cursor = db.rawQuery("          SELECT ... name LIKE ?1 " +          "UNIOn ALL SELECT ... name LIKE ?1 " +          ...          "UNIOn ALL SELECT ... name LIKE ?1",          new String[]{ searchText.getText().toString() + "%" });