LIKE and REGEXP Operators
LIKE and REGEXP Operators
- The LIKE keyword is used with the WHERE clause.
- The LIKE keyword and can use two symbols as wildcards. The percent ( % ) symbol matches any number of characters and the underscore ( _ ) matches a single character
- REGEXP keyword allows you to do more complex pattern matching than a LIKE keyword/
- Some version of REGEXP exists in many computer languages. Refer to the “LIKE and REGEXP” handout for a full list of examples.
Table 2. LIKE Keyword
|
LIKE Symbol |
Description |
|
% |
Match any string of characters to the left of the symbol |
|
_ |
Match a single character |
Code Example:
USE world;
SELECT name
FROM country
WHERE name LIKE ‘A%’
Results:
Table 3. REXEXP Keyword
|
REGEXP Characters |
Description |
|
^ |
Match the pattern to the beginning of the value being tested. |
|
$ |
Match the pattern to the end of the value being tested. |
|
. |
Matches any single character. |
|
[charlist] |
Matches any single character listed within the brackets. |
|
[char1 – char2] |
Matches any single character within the given range. |
|
| |
Separates two string patterns and matches either one |
Code Example:
USE world;
SELECT name
FROM country
WHERE name REGEXP 'g[o,u]';
Results:
CC BY-NC-ND International 4.0: This work is released under a CC BY-NC-ND International 4.0 license, which means that you are free to do with it as you please as long as you (1) properly attribute it, (2) do not use it for commercial gain, and (3) do not create derivative works.
End-of-Chapter Survey
: How would you rate the overall quality of this chapter?- Very Low Quality
- Low Quality
- Moderate Quality
- High Quality
- Very High Quality
Like this? Endorse it!