The primary options that you can use with the REGEXP operator to create expressions in your SQL statements.

       

Options             Meaning                               

<value>             The tested value must contain the specified value.

<^>                 The tested value must not contain the specified value.

.                   The tested value can contain any individual character represented by the period (.).

[<characters>]      The tested value must contain at least one of the characters listed within the brackets.

[<range>]           The tested value must contain at least one of the characters listed within the range of values enclosed by the brackets.

^                   The tested value must begin with the value preceded by the caret (^) symbol.

$                   The tested value must end with the value followed by the dollar sign ($) symbol.

*                   The tested value must include zero or more of the character that precedes the asterisk (*).

1.	REGEXP 'e'
2.	REGEXP '^ba'
3.	REGEXP and CONCAT
4.	REGEXP '[abc]'
5.	REGEXP 'm.n'
6.	REGEXP '[men][men]'
7.	POSTCODE REGEXP '[0-9][0-9][a-z][a-z]'
8.	NAME REGEXP '^[a-z]{7}'
9.	NAME REGEXP '^[a-z]{6,7}$'
10.	POSTCODE REGEXP '4{4}'
11.	REGEXP '[[.space.]]'
12.	REGEXP '[[:<:]]Street[[:>:]]'
13.	NAME REGEXP '^n.*e$'
14.	REGEXP '[a-z]{9}'
15.	Regular expressions do not match NULL values. This is true both for REGEXP and for NOT REGEXP
16.	SELECT c, c REGEXP '.', c REGEXP '^', c REGEXP '$' FROM mytable;
17.	With REGEXP, you need a double backslash to match a metacharacter literally:
18.	Be more specific with the REGEXP operator by extending the specified value used by the operator
19.	Pattern Matching with REGEXP
20.	The command REGEXP offers many more possibilities for formulating a pattern,

The primary options that you can use with the REGEXP operator to create expressions in your SQL statements. : REGEXP « Regular Expression « SQL / MySQL

Related examples in the same category