Select Query - WebSQL

Question

I've the following code to select a row.. When I call the function with getRecords("Peter Sam"); one record is shown.. However if I just pass getRecords("Peter"); it says "No results".

  getRecords = function(cname){
        db.transaction(function(tx) {
            tx.executeSql('SELECT * FROM contacts WHERE (cname LIKE ?)', [cname], renderResults);
        });
    }

What is the correct usage of "LIKE" in "Select" query?? BTW where do I refer SQL syntax for WebSQL?

Thanks

score 3 · Answer 1 · answered Jul 31 '13 at 06:35

3

getRecords = function(cname){
    db.transaction(function(tx) {
        tx.executeSql('SELECT * FROM contacts WHERE (cname LIKE ?)', ['%'+cname+'%'], renderResults);
    });
}

answered Jul 31 '13 at 06:35

Muhaimin CS

195
2
19

score 2 · Accepted Answer · answered Feb 04 '12 at 21:54

2

In transact SQL you would use a % as a wild card. something like:

SELECT * FROM contacts WHERE cname LIKE ?%

However, WebSQL has been discontinued so I don't suggest using this method.

answered Feb 04 '12 at 21:54

tnt-rox

5,400
2
38
52

3

Thanks for the response. The following query worked for me, SELECT * FROM contacts WHERE (cname LIKE ?);', ["%"+cname+"%"], renderResults Also do you suggest me to use indexedDB instead of WebSQL?? If so, is indexedDB is supported in Android 2.3?? – Naveen Feb 05 '12 at 07:27

score 0 · Answer 3 · answered Jul 10 '12 at 14:12

0

Use string concatenation:

SELECT * FROM contacts WHERE cname LIKE '%' || ? || '%'

answered Jul 10 '12 at 14:12

SystemParadox

8,203
5
49
57

Select Query - WebSQL

3 Answers3