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:
This content is provided to you freely by BYU-I Books.
Access it online or download it at https://books.byui.edu/learning_mysql/13_like_and_regexp_o.