what is "%abc%" and "abc%" and and "%abc" in couchbase(N1QL) filtering?

user_4652706 0
Viewed 230

What is the difference between "%abc%", "abc%" and "%abc" in couchbase where the condition column is

where name not like "%abc%"
 or name not like "%abc"
 or  name not like "abc%"
n1ql couchbase sql
1 Answers

If % is on both ends, there can be additional characters (one or several) before and after the given string, like "iuherviuhabcnjkdrg" or "fabcp"

If % is only at the beginning of the search term, the search is for strings that end with "abc", like "oiuztrabc" or "4abc". And if % is only at the end of the search term, the search is for strings that start with "abc"

Actually in your example, the whole logic is turned around by "is not" - so the opposite will apply to the results.

user_56416690
Related