jquerytaffydb

can I run a taffydb query ignoring case without combining it with like

I want to run a case insensitive query using TAFFYDB (upper/lower case). It appears that likenocase combines "like" with "no case". In other words, if I'm querying for "bm", I want BM,bm, Bm, bM. What I get, is all those plus anything with bm in it, line DNA_BM.

Is there a way to query out of taffy for ONLY case, without combining it with LIKE?

  var q=$("#clientID").val();        
  var ret=clientTechs({"clientID":{likenocase:q}}).get();

jsfiddle

Solution

  • According to the docs (http://taffydb.com/writing_queries.html)

    leftnocase Used to see if the start of a column is the same as a supplied value. Ignores case of column and value.

    isnocase Used to see if a column value is equal to a supplied value. Ignores case of column and value.