diff options
-rw-r--r-- | Docs/manual.texi | 26 |
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 | +----------+-------+---------+------+------------+------------+ |