yathit / ydn-db

Javascript database module for Indexeddb, Web SQL and localStorage storage mechanisms supporting version migration, advanced query, SQL and transaction.
Apache License 2.0
503 stars 41 forks source link

Where clause insensitive query search. #36

Closed amitgodse1 closed 9 years ago

amitgodse1 commented 9 years ago

Want to query database in insensitive manner. Is there anyway to achieve it?

where(field_name, op, value, op2, value2)

produce Case Sensitive query need to avoid case sensitiveness.

yathit commented 9 years ago

Currently you will have either 1) to use full-text search or 2) normalized the index.