Jump to: navigation, search

Mysql RLIKE

From w3cyberlearnings

Contents

MySQL RLIKE Function

This function is a synonym of REGEXP() function.

Syntax RLIKE

  • expre word or string
  • pat is a regular expression pattern matching.
expre RLIKE pat;

Example 1

mysql> SELECT 'good leader' RLIKE '^good .*r$';
+----------------------------------+
| 'good leader' RLIKE '^good .*r$' |
+----------------------------------+
|                                1 | 
+----------------------------------+
1 row in set (0.00 sec)

Related Links


Navigation
Web
SQL
MISC
References