How to search indexeddb for a string

Question

I am trying to set up a search feature on my site, i'm trying to find IndexedDB code for

SELECT "column" FROM "table" WHERE "column" LIKE "%keyword%"

i found a solution in IndexedDB Fuzzy Search

db.transaction(['table'], 'readonly')
    .objectStore('table')
    .openCursor(IDBKeyRange.bound(keyword, keyword + '\uffff'), 'prev')
    .onsuccess = function (e) {
        e || (e = event);
        var cursor = e.target.result;
        if (cursor) {
            console.log(cursor.value.column);
            cursor.continue();
        }
    };

but how can i find "%keyword%" instead of "%keyword" ?

I'm not exactly sure how this all works so I'm just guessing, but what about `IDBKeyRange.bound('\uffff' + keyword, keyword + '\uffff')` ? — Ian, Apr 14 '13 at 03:59
it doesnt work, return error `DataError: DOM IDBDatabase Exception 0` — Chito Adinugraha, Apr 14 '13 at 04:10
possible duplicate of [IndexedDB Fuzzy Search](http://stackoverflow.com/questions/7086180/indexeddb-fuzzy-search) — Josh, May 25 '14 at 02:29
@Josh no, I don't think it's a duplicate. The OP clearly mentions what is different. — Shadow The GPT Wizard, May 25 '14 at 13:05

score 4 · Accepted Answer · answered Apr 29 '13 at 08:44

There is nothing similar to SQL WHERE in IndexedDB.

I would loop through the table/object store values and see if the current cursor column contains the keyword:

var keyword = "foo";
var transaction = db.transaction("table", "readwrite");
var objectStore = transaction.objectStore("table");
var request = objectStore.openCursor();
request.onsuccess = function(event) {
    var cursor = event.target.result;
    if (cursor) {
        if (cursor.value.column.indexOf(keyword) !== -1) {                
            console.log("We found a row with value: " + JSON.stringify(cursor.value));
        }  

        cursor.continue();          
    }
};

this is slow, should it be better with index and index value range? — Dee, Dec 18 '20 at 04:36

How to search indexeddb for a string

1 Answers1