Loading ...
Sorry, an error occurred while loading the content.

Re: How to do non-case sensitive "Like" query

Expand Messages
  • purpleflurm
    You can actually use likenocase instead of like , and it will work, e.g. {name: {likenocase:_q}}
    Message 1 of 2 , Mar 26 3:05 PM
    • 0 Attachment
      You can actually use "likenocase" instead of "like", and it will work, e.g. {name: {likenocase:_q}}

      --- In taffydb@yahoogroups.com, "xybrek88" <xybrek@...> wrote:
      >
      > I have this query that works pretty well:
      >
      > var _q = "some query"
      > products([{name:{like:_q}},{info:{like:_q}}]).select("id");
      >
      > However, the query is case sensitive and that "Banana" would not result to getting records with "banana" (case sensitive)
      >
      > Is there a work around to do non-case sensitive queries?
      >
    Your message has been successfully submitted and would be delivered to recipients shortly.