- Access full-text search, blazing speed, and effortless scalability using a familiar query syntax
- A caveat: search criteria on text must match case spelling of the document value
- Sample query:
"SELECT ACC_DATE, ACC_TIME, BARRACK FROM collisions WHERE BARRACK='Rockville' LIMIT 5" - Result:
ACC_DATE | ACC_TIME | BARRACK ----------------------+---------------+--------------- 01/01/2012 12:00:00 AM|2:01 |Rockville 01/01/2012 12:00:00 AM|18:01 |Rockville 01/02/2012 12:00:00 AM|11:01 |Rockville 01/03/2012 12:00:00 AM|4:01 |Rockville 01/03/2012 12:00:00 AM|18:01 |Rockville