Skip to content
Advertisement

How to remove certain results from my search count?

I received a few irrelevant results to my count that I would like to remove from my output.

When using only the first “where lower (person) not like ‘%c%'” worked but when adding person b, c etc. as shown it gave me the original irrelevant results.

What should I change?

Expected results:

Advertisement

Answer

You want AND, not OR:

This is logically equivalent to:

Or more concisely:

Or if you want to be a bit inscrutable:

The (?i) makes the pattern matching case-insensitive.

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement