N1QL query - for LIKE statement - Index

SQL++
1

Hi,
we have a document like below,
{
“CtryCd”: “157”,
“CustDsplyNm”: “BP HP”
}
we would like to query on the CustDsplyNm field with LIKE query, for example CustDsplyNm like “%HP” or CustDsplyNm like “BP%”

also we are thinking to use CONTAINS_TOKEN_LIKE(CustDsplyNm ,"%HP")

Is it a way to do this? also what is the optimum way to create index for these kind of queries?

Thanks

2

Check Page 113 of https://blog.couchbase.com/wp-content/uploads/2017/10/N1QL-A-Practical-Guide-2nd-Edition.pdf