SQLite Search Query

Question

I want to Search from Local Storage , What will be the Sqlite Query for Ionic2 for this- What will be the sql query for searching a number from local storage. Something like this- select row_id from mytable where * like '%searched_text%';

 var searchmobile=newvalue
          this.database.executeSql("SELECT mobile_no FROM customer WHERE mobile_no like ?",
            [searchmobile]).then((customerdata) =>

http://stackoverflow.com/questions/12613926/sqlite-query-like — Suraj Rao, Apr 16 '17 at 11:36
@suraj I have to pass a variable "searchmobile", how to do it? — Aditya Kumar, Apr 17 '17 at 05:24

score 0 · Answer 1 · answered Apr 17 '17 at 05:37

0

Try concatenating searchmobile like:

 var searchmobile=newvalue
          this.database.executeSql("SELECT mobile_no FROM customer WHERE mobile_no like ?",
            ['%' + searchmobile + '%']).then((customerdata) =>

answered Apr 17 '17 at 05:37

Suraj Rao

29,388
11
94
103

score 0 · Answer 2 · answered Apr 17 '17 at 05:51

u need to open the database before executing a query

`var searchmobile=newvalue
this.database = new SQLite();
this.database.openDatabase({
        name: "data.db",
        location: "default"
      }).then(() => {
this.database.executeSql("SELECT mobile_no FROM customer WHERE mobile_no like ?",
            [searchmobile]).then((customerdata) =>`

SQLite Search Query

2 Answers2