Similar to SQL "LIKE" statement in Couchbase
Is this possible in Couchbase??
SELECT * FROM users WHERE user_name LIKE '%john%'.
Seems like I have to use startkey and endkey. But doesn't seem to get the right results.
Also what is the use of startkey_docid? Cause to me it seems like "LIKE '%john'" in SQL but still it doesn't seem to be very satisfactory.