View Sidebar

Post Tagged with: sqlite

SQLite Database NoCase Sensitive Search

SQLite Database NoCase Sensitive Search

Working on Search operation in SQLite database can be tricky. The text search operation on SQLite database is by default case sensitive, due to which you can miss out on quite a few results. To make the search query ignore the cases and work irrespective of any input provided the […]

April 30, 2014Read More
Insert or Update entries in SQLite Database

Insert or Update entries in SQLite Database

Often when working with SQLite Database in Mobile Applications you require to check whether the data row already exist or not. Depending on which if the data is already present you could UPDATE the row or INSERT if not present. The solution is to use REPLACE query to do this, REPLACE […]