15 Best SQL Queries for Developers [SQL Queries]

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.


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

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 SQL WHERE LIKE Statement Reviewed by Anil Singh on 1:38 AM Rating: (5)
www.code-sample.com/. Powered by Blogger.
^