SQL_Playground/Like.txt at master · lakshay2k/SQL_Playground · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
* Select all records where the value of the City column starts with the letter "a".
-> SELECT * FROM Customers WHERE City LIKE 'a%';

* Select all records where the value of the City column ends with the letter "a".
-> SELECT * FROM Customers WHERE City LIKE '%a';

* Select all records where the value of the City column contains the letter "a".
-> SELECT * FROM Customers WHERE City LIKE '%a%';

* Select all records where the value of the City column starts with letter "a" and ends with the letter "b".
-> SELECT * FROM Customers WHERE City LIKE 'a%b';

* Select all records where the value of the City column does NOT start with the letter "a".
-> SELECT * FROM Customers WHERE City NOT LIKE 'a%';