: REGEXP : Regular Expressions MySQL TUTORIALS
Ajax
Ajax Examples
Ajax Tutorials
Scripts and Programs
Javascript
Javascript Examples Tutorials
DHTML Tutorials
Javascript References
Scripts and Programs
HTML
HTML Tutorials
HTML References
HTML DOM 0 References
HTML DOM 2 References
CSS
CSS Tutorials
CSS References
PHP
PHP Source Code
PHP References
Scripts and Programs
C#
C# Source Code
C# Examples
MySQL TUTORIALS
»
Regular Expressions
»
REGEXP
»
436.1 .
REGEXP '^[mn].*[sz]$'
Hits: 1273
436.2 .
REGEXP '^[a-f]'
Hits: 1400
436.3 .
SELECT '1+2' REGEXP '1\\+2';
Hits: 1201
436.4 .
To find names containing exactly five characters using {n}
Hits: 1295
436.5 .
To find names containing exactly five characters
Hits: 1271
436.6 .
To find names containing an 'e', use this query
Hits: 1122
436.7 .
To find names ending with 'es', use '$' to match the end of the name
Hits: 1138
436.8 .
To matches only lowercase 'b' at the beginning of a name
Hits: 1176
436.9 .
To find names beginning with 'J', use '^' to match the beginning of the name
Hits: 1151
436.10 .
Characters and classes used by the REGEXP and NOT REGEXP operators (or RLIKE and NOT RLIKE, which are synonyms)
Hits: 1233
MySQL TUTORIALS
Regular Expressions
»
REGEXP
Introduction
Occurrences
Anchor End
One or More
Anchor Start
REGEXP
Any Character
Sequence
Bracket
Word
Character_class
Zero or More
Not
Zero or One
Aggregate Functions
Cast Functions Operators
Comparison Functions Operators
Control Flow Functions
Cursor
Data Dictionary
Data Types
Database
Date Time Functions
Encryption Compression Functions
Information Functions
Insert Update Delete
Introduction
Logic Operator
Math Numeric Functions
Miscellaneous Functions
MySQL Utilities
Privilege
Procedure Function
Regular Expressions
Select Query
String Functions
Subquery
Table
Table Join
Trigger
View
![REGEXP '^[mn].*[sz]$'](res.png "REGEXP '^[mn].*[sz]$'"){kind=small}
REGEXP '^[mn].*[sz]$'
