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 …

N1QL query - for LIKE statement - Index

vsr1 August 24, 2020, 1:11pm 2

Topic		Replies	Views
N1QL for like queries SQL++	4	19944	May 21, 2017
LIKE operator in N1ql query not working SQL++	1	1583	January 10, 2019
N1ql like query indexes SQL++	2	732	February 27, 2020
Query search like %search% SQL++ query , n1ql , server , index	3	1181	February 6, 2020
Indexing LIKE predicates SQL++	2	1414	January 23, 2020