Query search like %search%

[vsr1]

Indexing LIKE predicates

Have the following document as an example: { "id": "9ed72dd0-8c8c-449b-91e5-880b8d864887", "type": "human", "name": "John David Smith" } Then consider the following query: SELECT document.* FROM bucket WHERE document.name LIKE "%David%" How would one index the name field so that documents containing David can be queried efficiently?