- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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’.
- Related Articles
- How to use RLIKE/REGEXP patterns in MySQL?
- What are the different wildcard characters that can be used with MySQL RLIKE operator?
- What is the use of SOUNDS LIKE operator in MySQL?
- 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 EXIST and EXIST NOT operator with MySQL subqueries?
- What is the use of sizeof Operator in C#?
- What is the use of tilde operator (~) in R?
- What is the operator in MySQL?
- What is the use of scope resolution operator in C++?
- Explain the use of sql LIKE operator using MySQL in Python?
- What is the use of NCHAR in MySQL?
- What is the use of FIND_IN_SET () function in MySQL?
- What is the use of LOCATE() function in MySQL?

Advertisements