Characters and classes used by the REGEXP and NOT REGEXP operators (or RLIKE and NOT RLIKE, which are synonyms) : REGEXP : Regular Expressions MySQL TUTORIALS

MySQL TUTORIALS » Regular Expressions » REGEXP »

Characters and classes used by the REGEXP and NOT REGEXP operators (or RLIKE and NOT RLIKE, which are synonyms)

'.' matches any single character.

A character class '[...]' matches any character within the brackets.

For example, '[abc]' matches 'a', 'b', or 'c'.

To name a range of characters, use a dash.

'[a-z]' matches any letter, whereas '[0-9]' matches any digit.

'*' matches zero or more instances of the thing preceding it.

For example, 'x*' matches any number of 'x' characters.

'[0-9]*' matches any number of digits.

'.*' matches any number of anything.

A REGEXP pattern match succeeds if the pattern matches anywhere in the value being tested.

A LIKE pattern match succeeds only if the pattern matches the entire value.

'^' matches the beginning of the pattern.

'$' matches the end of the pattern.

Related Scripts with Example Source Code in same category :

To find names beginning with 'J', use '^' to match the beginning of the name
To matches only lowercase 'b' at the beginning of a name
To find names ending with 'es', use '$' to match the end of the name
To find names containing an 'e', use this query
To find names containing exactly five characters
To find names containing exactly five characters using {n}
SELECT '1+2' REGEXP '1\\+2';
REGEXP '^[a-f]'
REGEXP '^[mn].*[sz]$'

MySQL TUTORIALS

Regular Expressions
» REGEXP

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

Privilege

Subquery

Table

Table Join

Trigger

View

Characters and classes used by the REGEXP and NOT REGEXP operators (or RLIKE and NOT RLIKE, which are synonyms) : REGEXP : Regular Expressions MySQL TUTORIALS

MySQL TUTORIALS » Regular Expressions » REGEXP »

Characters and classes used by the REGEXP and NOT REGEXP operators (or RLIKE and NOT RLIKE, which are synonyms)

Leave a Comment / Note

MySQL TUTORIALS