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!!