SQL WHERE LIKE Statement

The SQL “LIKE” operator is use with “WHERE” clause to search a specific string in the columns and Here is “two” wildcard characters (%) percent and (_) underscore using LIKE operator.

The percent sign (%) represents zero, one or multiple characters and the underscore (_) represent a single character or number.

Stayed Informed - 37 Best SQLServer Interview Questions and Answers

Syntax:-

SELECT ColumnName, ColumnName
     FROM TableName
WHERE ColumnName LIKE value

Examples:-

--SELECT ALL COUNTRY
SELECT * FROM Countries

Result :-

Id CountryName CountryCode
-----------------------------------
1 India        IN
2 Nepal        NP
3 USA        US
4 Rasia        RA

Query:-

--SELECT WHERE LIKE
SELECT Id, CountryName
  FROM Countries WHERE CountryName LIKE 'I%'

Result:-

Id CountryName
-------------------
1 India

Query:-

SELECT Id, CountryName
  FROM Countries WHERE CountryName LIKE '%a'

Result:-

Id CountryName
-------------------
1 India
3 USA
4 Rasia

Query:-

SELECT Id, CountryName
  FROM Countries WHERE CountryName LIKE 'Indi_'

Result:-

Id CountryName
-------------------
1 India

Stayed Informed - SQL Server Query and Examples

I hope you are enjoying with this post! Please share with you friends. Thank you!!

Pin it

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

SQL WHERE LIKE Statement

Reviewed by Anil Singh on 1:38 AM Rating: (5)