5. Introducing N1QL | Couchbase Essentials

String utilities

One of the more obvious limitations of querying views is the lack of a proper LIKE operator. Though we saw in Chapter 4, Advanced Views, that it is possible to emulate a query like "starts with", it is not as robust as SQL's LIKE operator.

Fortunately, N1QL addresses this limitation with its own LIKE operator. Similar to SQL, you define a search pattern with a wildcard that is specified by a % character. In the following snippet, all breweries with Boston in their name will be returned in the results:

SELECT *
FROM brewery-sample
WHERE type = "brewery"
AND name LIKE "%Boston%"

Other string operators exist to perform standard string transformations such as SUBSTR, LOWER, UPPER, and LENGTH. You can use these functions as you do in a JavaScript map function or with string operations in most frameworks:

SELECT *
FROM beer-sample
WHERE type = "brewery"
AND LOWER(name) ="thomas hooker brewing"

It's also possible to perform string concatenation using the double pipe (||) operator. You...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Couchbase Essentials

By : John C Zablocki

Couchbase Essentials

By: John C Zablocki

Overview of this book

String utilities

Couchbase Essentials

By : John C Zablocki

Couchbase Essentials

By: John C Zablocki

Overview of this book

String utilities

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access