5.21- SQL like & Not like Operator | SQL Online Free Course | Microsoft Sql Server | Learn Sql

5.21- SQL like & Not like Operator | SQL Online Free Course | Microsoft Sql Server | Learn Sql

#sqltutorials #sqlonline #sqlDBMS #MSSQL#gatedbmslecturesinhindi
#ugcnetdbmslecturesinhindi #gatedbmslectures #ugcnetdbmslectures
#dbmslectures #dbmstutorials

PLAYLIST:

Complete Playlist:

SQL - Structured Query Language By Using MSSQL In DBMS In Hindi
https://www.youtube.com/playlist?list=PLL8qj6F8dGlRlQgG60v1OxSZDmSaSbsHc

(English)SQL using Microsoft SQL Server | Microsoft Sql Server
https://www.youtube.com/playlist?list=PLL8qj6F8dGlSR00PnE-EMQ7PENd3raeMf

DBMS - Data Base Management System Tutorials | All University Exams - UGC NET- GATE DBMS Lectures
https://www.youtube.com/playlist?list=PLL8qj6F8dGlSZrqH37DY_4rsfeOkieH54

[With Notes & PDF File] | Database Management System In HINDI
https://www.youtube.com/playlist?list=PLL8qj6F8dGlSZYUFrX6ASTdFWiUlLjguc

introduction to sql course,
learn sql tutorial,
sql quick tutorial,
sql coding tutorial,
sql server tutorial for beginners,
ms sql server tutorial for beginners,
order by asc, order by desc

dbms lectures,
dbms gate lectures in hindi,
gate dbms tutorials,
ugc net dbms tutorials,

The SQL LIKE Operator
The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

There are two wildcards often used in conjunction with the LIKE operator:

The percent sign (%) represents zero, one, or multiple characters
The underscore sign (_) represents one, single character
Note: MS Access uses an asterisk (*) instead of the percent sign (%), and a question mark (?) instead of the underscore (_).

The percent sign and the underscore can also be used in combinations!

LIKE Syntax
SELECT column1, column2, ...
FROM table_name
WHERE columnN LIKE pattern;
Tip: You can also combine any number of conditions using AND or OR operators.

Here are some examples showing different LIKE operators with '%' and '_' wildcards:

LIKE Operator Description
WHERE CustomerName LIKE 'a%' Finds any values that start with "a"
WHERE CustomerName LIKE '%a' Finds any values that end with "a"
WHERE CustomerName LIKE '%or%' Finds any values that have "or" in any position
WHERE CustomerName LIKE '_r%' Finds any values that have "r" in the second position
WHERE CustomerName LIKE 'a_%' Finds any values that start with "a" and are at least 2 characters in length
WHERE CustomerName LIKE 'a__%' Finds any values that start with "a" and are at least 3 characters in length
WHERE ContactName LIKE 'a%o' Finds any values that start with "a" and ends with "o"

SQL LIKE Examples
The following SQL statement selects all customers with a CustomerName starting with "a":

Example
SELECT * FROM Customers
WHERE CustomerName LIKE 'a%'; Notes Link:
http://www.tutorialsspace.com/Download-Pdf-Notes/DBMS-Notes.aspx