SQLite Search Query

Ionic Framework ionic-v3
1

I want to Search from Local Storage , What will be the Sqlite Query 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) =>