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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Buy Books Online at Best Prices

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.