Cursor findNormalItems = db.query("items", columns, "type=?",
new String[] { "onSale" });
I want to return the cursor that points anything that are NOT onSale, what should I change? Thanks!
Add a comment
|
4 Answers
From the official documentation:
The non-equals operator can be either
!=or<>
So your code becomes:
Cursor findNormalItems = db.query("items", columns, "type != ?",
new String[] { "onSale" });
4 Comments
Boycott A.I.
In my opinion,
!= looks more professional - and is more consistent with the = and == operators.
ThierryC
why I have to add "OR 'mycolumn' IS NOT NULL ? When I query with a where clause NOT EQUAL ?
edc65
@ban-geoengineering
<> is SQL Ansi standard and != is not. Of course <> is more professionalYou should use in the comparator the non-equal operator:
"type!=?" or "type<>?".
Comments
You can use <> operator
You will find here all the basic sql statements
2 Comments
v010dya
Link is dead, consider updating it please
Amr Angry
@v010dya Apologies for that. This was answered a long time ago, and I believe the article has been removed since then. As mentioned, you could use type<>? to solve the issue of inequality in an SQL query. Let me know if I can assist further by helping resolve your specific case study.
With rawQuery :
quranCursor = db.rawQuery("SELECT * from alquran WHERE sura_id = '" + sooraId + "' AND ayat_id !='" + "0" + "'", null);
Usage:
int sooraId = 3 ;
try {
// start from not 0, but 1 ; Include All row but ayat_id = 0 :
quranCursor = db.rawQuery("SELECT * from alquran WHERE sura_id = '" + sooraId + "' AND ayat_id !='" + "0" + "'", null);
} catch (Exception e) {
e.printStackTrace();
}
This is tested one of my app, and works fine, Alhamdulillah.
