SQL Patterns
SQL Patterns is an alternative search option that uses the LIKE operator to match patterns in text strings. Below are the SQL patterns equivalent to the REGEXP patterns mentioned:
|
SQL Pattern
|
Description
|
|---|---|
| co% | Matches strings that begin with the substring "co". |
| %er | Matches strings that end with the substring "er". |
| %er% | Matches strings that contain the substring "er" at any position. |
| __pp% | Matches strings that contain the substring "pp" at a specific position (starting after two characters). |