mysql
  1. mysql-mysqlrlike
PreviousNext

MySQL RLIKE - (MySQL Regular Expressions)

MySQL RLIKE (Regular Expression) is a comparison operator that is used to match a string value with a regular expression. In this tutorial, we'll discuss the syntax, example, output, explanation, use, important points, and summary of MySQL RLIKE.

Syntax

The syntax for using the RLIKE operator in MySQL is as follows:

SELECT column_name FROM table_name WHERE column_name RLIKE pattern;

Here, "column_name" is the name of the column you want to search, "table_name" is the name the table that contains the column, and "pattern" is the regular expression you want to match against.

Example

Suppose we have a table called "users" that contains a column called "email." We want to retrieve all the email addresses that contain the word "gmail." Here's how we can do that using RLIKE operator:

SELECT email
FROM users
WHERE email RLIKE 'gmail';

Output

When we run the example code above, the output will be a list of email addresses that contain the word "gmail."

Explanation

In the example above, we used the RLIKE operator to search for email addresses that contain the word "gmail." The regular expression 'gmail' matches any string that contains the characters 'gmail.'

Use

The RLIKE operator is used to search for string patterns in a database column using regular expressions. It is useful when you need to search for data based on a complicated pattern rather than a simple keyword.

Important Points

  • The RLIKE operator is not case-sensitive. To perform a case-sensitive search, use the REGEXP operator instead.
  • The regular expression used with RLIKE must follow the POSIX standard.
  • The RLIKE operator can be combined with other operators, such as the AND and OR operators, to create more complex queries.

Summary

In this tutorial, we discussed the MySQL RLIKE operator, which is used to search for a pattern in a column using regular expressions. We covered the syntax, example, output, explanation, use, and important points of MySQL RLIKE. With this knowledge, you can use RLIKE operator to search for complex patterns in your MySQL databases.

Regular ExpressionsNot Like Operator
Published on: