mysql
  1. mysql-like
PreviousNext

LIKE - MySQL Conditions

The LIKE keyword is a powerful operator used in MySQL to select data based on pattern matching. It is often used with the WHERE clause to specify a condition for retrieving data that matches a certain pattern. In this tutorial, we will explore the syntax, example, output, explanation, use, important points, and summary of LIKE operator in MySQL.

Syntax

The basic syntax of the LIKE operator is as follows:

SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern;

The pattern can include one or more wildcards to match any character or set of characters.

Example

Let's say we have a table named "employees" with the following data:

+----+-----------+----------+
| id | name      | email    |
+----+-----------+----------+
| 1  | John Doe  | john@abc.com |
| 2  | Jane Doe  | jane@abc.com |
| 3  | James Lee | james@xyz.com|
| 4  | Mary Smith| mary@xyz.com |
+----+-----------+----------+

We can use the LIKE operator to retrieve all employees whose email address ends with ".com". Here is the syntax:

SELECT * FROM employees WHERE email LIKE '%.com';

The output of this query would be:

+----+-----------+----------+
| id | name      | email    |
+----+-----------+----------+
| 1  | John Doe  | john@abc.com |
| 2  | Jane Doe  | jane@abc.com |
| 3  | James Lee | james@xyz.com|
| 4  | Mary Smith| mary@xyz.com |
+----+-----------+----------+

Explanation

In the example above, we used the LIKE operator to retrieve all employees from the "employees" table whose email address ends with ".com". The "%" symbol is used as a wildcard to match any set of characters.

Use

The LIKE operator is a powerful tool for selecting data based on pattern matching. It is commonly used to find records that contain a certain string or set of characters. Some common uses include:

  • Finding records where a specific column contains a certain pattern.
  • Searching for data that matches a certain pattern across multiple columns.

Important Points

  • The "%" symbol is used as a wildcard to match any set of characters in a pattern.
  • The "_" symbol can be used to match a single character in a pattern.
  • LIKE is not case-sensitive by default, but it can be modified with the LOWER or UPPER function.

Summary

In this tutorial, we explored the LIKE operator in MySQL. We looked at the syntax, example, output, explanation, use, and important points of the LIKE operator. The LIKE operator is a powerful tool for selecting data based on pattern matching and can be used to find records that contain a certain string or set of characters.

BooleanIN
Published on: