[Solved] Looking for a collection of data with no clear pattern [closed]

by


The solution I have in mind is to run the query with an AND for all
the data that does have a pattern

Well, if you want to find everything that doesn’t follow any pattern just enclose all the patterns within brackets and combine with boolean AND.

Then just put a NOT outside the brackets.

Example:

select * from data where
NOT (CONDITION1 AND CONDITION2 AND...AND CONDITION_N)

I imagine your conditions are statements such as string comparisons using like (and wildcards) in addition to arithmetic comparisons.

1

solved Looking for a collection of data with no clear pattern [closed]