In MySQL, regular expressions are used in queries for searching a pattern in a string.
* *
Matches 0 more instances of the string preceding it.
* +
matches one more instances of the string preceding it.
* ?
Matches 0 or 1 instances of the string preceding it.
* .
Matches a single character.
* [abc]
matches a or b or z
* |
separates strings
* ^
anchors the match from the start.
* "."
Can be used to match any single character. "|" can be used to match either of the two strings
* REGEXP
can be used to match the input characters with the database.
Example :
The following statement retrieves all rows where column employee_name contains the text 1000 (example salary):
Select employee_name
From employee
Where employee_name REGEXP '1000'
Order by employee_name