MySQL Regexp Operator

Regexp is an operator of MySQL. It is used for pattern matching. It compares the given pattern in the column and returns the items which are matching with the patterns.

Syntax

snippet
select name from table_name where column_name regexp 'pattern';

Example 1

Database:

MySQL Regexp Operator

Insert:

MySQL Regexp Operator

Table:

MySQL Regexp Operator

Query:

MySQL Regexp Operator
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents +