Rapid Android Development

Refine SQLite Results Using WHERE Clauses

Since we recorded data into a SQLite database, we can do much more with the data than parsing our data row by row. For example, KetaiSQLite methods can help us get the minimum and maximum values of a particular field in our table. This comes in very handy when we’re displaying time-series graphs and want to distribute our data points evenly across a display in a way that takes full advantage of the available pixel real estate of each Android device.

Conditional SQL queries using WHERE clauses allow us to search table records that match a particular value we specify in our clause. It returns all rows for which the WHERE clause is true. WHERE clauses are often used with one of the following operators: ...