- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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’.
Updated on 07-Feb-2020 11:10:06
- 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?
- 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 sizeof Operator in C#?
- What is the use of tilde operator (~) in R?
- What is the use of EXIST and EXIST NOT operator with MySQL subqueries?
- What is the use of scope resolution operator in C++?
- 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?
Advertisements