CODEWITHSUNDEEP
dbflow
HealthyRyu
HealthyRyu

Reputation: 107

How to use Between in DBFlow

I Want to make Between Query in DBflow,
like that:

Select * From MYTABLE where MYTABLE.NO BETWEEN num1 AND num2

But I don't know that how to use between.

I usually used query like that

public Score find(String No) {
    return SQLite.select()
            .from(Score.class)
            .where(Score_Table.No.eq(No))
            .querySingle();
}

Upvotes: 2

Views: 504

Answers (1)

Piyush Gupta
Piyush Gupta

Reputation: 2179

You can use between condition like this:

public Score find(String No) {
    return SQLite.select()
            .from(Score.class)
            .where(Condition.column(Score_Table.No).between(value1).and(value2))
            .querySingle();
}

Upvotes: 3

Related Questions