LIKE Query in SQL - A Comprehensive Guide

Process Advisors

ey-logo
*Subject to Terms and Condition

How to search a specified pattern in a column in SQL?

It is used to search a specified pattern in a column. The two wildcards operator used in conjunction with the LIKE operator.

  • % – The percent sign is used to represent one or more characters.
  • _ – The underscore sign is used to represent only one Character.

Syntax:

SELECT column1, column2….
FROM table_name
WHERE column1 LIKE %XXX;
‘OR’
SELECT column1, column2….
FROM table_name
WHERE column1 LIKE %XXX%;
‘OR’
 
SELECT column1, column2….
FROM table_name
WHERE column1 LIKE _XXX;
‘OR’
SELECT column1, column2….
FROM table_name
WHERE column1 LIKE XX_X;
‘OR’
SELECT column1, column2….
FROM table_name
WHERE column1 LIKE %XX_X;
Example:
SELECT Name, Roll_no
FROM Student_details
WHERE Name LIKE %tesh;

 

Name Roll No.
Jitesh 6

Become a Database Architect

Get a comprehensive overview of how SQL INNER JOIN works, with examples and illustrations!

Course Schedule

Name Date Details
SQL Training 30 Sep 2023(Sat-Sun) Weekend Batch
View Details
SQL Training 07 Oct 2023(Sat-Sun) Weekend Batch
View Details
SQL Training 14 Oct 2023(Sat-Sun) Weekend Batch
View Details

Leave a Reply

Your email address will not be published. Required fields are marked *