CODEWITHSUNDEEP
jquerytaffydb
Shawn
Shawn

Reputation: 3159

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

Upvotes: 0

Views: 74

Answers (1)

imvain2
imvain2

Reputation: 15847

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.

Upvotes: 1

Related Questions