summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--Docs/manual.texi26
1 files changed, 21 insertions, 5 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi
index 9535fee0adc..a86e51d0a87 100644
--- a/Docs/manual.texi
+++ b/Docs/manual.texi
@@ -24782,10 +24782,10 @@ To demonstrate how extended regular expressions work, the @code{LIKE} queries
shown above are rewritten below to use @code{REGEXP}.
To find names beginning with @samp{b}, use @samp{^} to match the beginning of
-the name and @samp{[bB]} to match either lowercase or uppercase @samp{b}:
+the name:
@example
-mysql> SELECT * FROM pet WHERE name REGEXP "^[bB]";
+mysql> SELECT * FROM pet WHERE name REGEXP "^b";
+--------+--------+---------+------+------------+------------+
| name | owner | species | sex | birth | death |
+--------+--------+---------+------+------------+------------+
@@ -24794,6 +24794,23 @@ mysql> SELECT * FROM pet WHERE name REGEXP "^[bB]";
+--------+--------+---------+------+------------+------------+
@end example
+Prior to MySQL 3.23.4, @code{REGEXP} is case sensitive, and the previous
+query will return no rows. To match either lowercase or uppercase @samp{b},
+use this query instead:
+
+@example
+mysql> SELECT * FROM pet WHERE name REGEXP "^[bB]";
+@end example
+
+From MySQL 3.23.4 on, to force a @code{REGEXP} comparison to be case
+sensitive, use the @code{BINARY} keyword to make one of the strings a
+binary string. This query will match only lowercase @samp{b} at the
+beginning of a name:
+
+@example
+mysql> SELECT * FROM pet WHERE name REGEXP BINARY "^b";
+@end example
+
To find names ending with @samp{fy}, use @samp{$} to match the end of the
name:
@@ -24807,11 +24824,10 @@ mysql> SELECT * FROM pet WHERE name REGEXP "fy$";
+--------+--------+---------+------+------------+-------+
@end example
-To find names containing a @samp{w}, use
-@samp{[wW]} to match either lowercase or uppercase @samp{w}:
+To find names containing a lowercase or uppercase @samp{w}, use this query:
@example
-mysql> SELECT * FROM pet WHERE name REGEXP "[wW]";
+mysql> SELECT * FROM pet WHERE name REGEXP "w";
+----------+-------+---------+------+------------+------------+
| name | owner | species | sex | birth | death |
+----------+-------+---------+------+------------+------------+