 |
|
 |
| |
Developer on focus
Anton Zamov is a dipl. engineer with more than 6 years of active professional
experience and many awards ...
read more>>
|
|
 |
 |
 |
|
|
|
|
| |
|
How to use regular expressions in MySQL database queries?
|
One of the things I like the most in MySQL is
the possibility to use regular expressions in the SQL
queries.
A very simple example illustrating this is to select
all the records from MyTable for which MyField starts with "A"
SELECT * FROM MyTable WHERE MyField REGEXP '^a';
Please take a look to the list below in order to find more information
for the available options
MySQL Regular Expressions
*
Matches zero or more instances of the string preceding it
+
Matches one or more instances of the string preceding it
?
Matches zero or one instances of the string preceding it
.
Matches any single character
[xyz]
Matches any of x, y, or z (the characters within the brackets)
[A-Z]
Matches any uppercase letter
[a-z]
Matches any lowercase letter
[0-9]
Matches any digit
^
Anchors the match from the beginning
$
Anchors the match to the end
|
Separates strings in the regular expression
{n,m}
String must occur at least n times, but no more than n
{n}
String must occur exactly n times
{n,|
String must occur at least n times
|
About the author of this programming example or tutorial:
Anton Zamov is a software engineer with more than6 years
of active experience in web and software development and design.
Anton Zamov has extensive experience and broad knowledgebase
in C# and JAVA programming and has created a lot of
running e-commerce systems, portals and content management
systems using PHP and other web development technologies.
For more information about Anton Zamov, you may visit the personal web site of
Anton Zamov.
|
|
|
|
|
|
|
|
