What is the use of RLIKE operator in MySQL?

Actually, RLIKE operator, a synonym for REGEXP, performs a pattern match of a string expression against a pattern. 

Syntax

RLIKE Pat_for_match

Here Pat_for_match is a pattern which is to be matched against an expression. 

Example

mysql> Select Id, Name from Student WHERE Name RLIKE 'v$';
+------+--------+
| Id   | Name   |
+------+--------+
| 1    | Gaurav |
| 2    | Aarav  |
| 20   | Gaurav |
+------+--------+
3 rows in set (0.00 sec) 

Here, $ is wildcard used with RLIKE operator which will find the name of the student ending with ‘v’.

Anjana

Published on 20-Feb-2018 11:40:12

• Related Questions & Answers
• What is the use of MySQL NOT LIKE operator?
• What is the use of MySQL SOUNDS LIKE operator?
• What is the use of MySQL IS and IS NOT operator?
• What is the use of SOUNDS LIKE operator in MySQL?
• What are the different wildcard characters that can be used with MySQL RLIKE operator?
• How to use RLIKE/REGEXP patterns in MySQL?
• What is the use of sizeof Operator in C#?
• What is the use of tilde operator (~) in R?
• What is the use of scope resolution operator in C++?
• What is the use of EXIST and EXIST NOT operator with MySQL subqueries?
• What is the use of NCHAR in MySQL?
• What is the operator <=> in MySQL?
• What is the use of MySQL FROM_UNIXTIME() function?
• What is the use of MySQL GET_FORMAT() function?
• What is the use of MySQL LAST_INSERT_ID() function?