Using a Regular Expression REGEXP in a WHERE Statement

What you can do with a Regular Expression may differ between environments but the concept is the same Evaluate target data based on it’s characteristics

Let’s Start with some common REGEXP Syntax

^ Is at the Start of the Target

$ Is at the End of the Target

. Placeholder/counter in a List

[xyz] A list of desired target matches

[x-z] A Range of desired target matches

{n} Repeat prefix command n times

BINARY Exact Match (Lower vs Upper Case)

^M: MyTagret

$t: MyTagret

[abc]: MyTagret

[f-j]: MyTagret

^……..$: MyTagret

^.{8}$: MyTagret

Let’s Look at Some Examples

| The Logical OR Operator