1WHERE CustomerName LIKE 'a%'
2--Finds any values that start with "a"
3WHERE CustomerName LIKE '%a'
4--Finds any values that end with "a"
5WHERE CustomerName LIKE '%or%'
6--Finds any values that have "or" in any position
7WHERE CustomerName LIKE '_r%'
8--Finds any values that have "r" in the second position
9WHERE CustomerName LIKE 'a__%'
10--Finds any values that start with "a" and are at least 3 characters in length
11WHERE ContactName LIKE 'a%o'
12--Finds any values that start with "a" and ends with "o"
1#SELECT * FROM table_name WHERE columnName LIKE pattern;
2SELECT * FROM wilayah_2020 WHERE kode LIKE "82%"
3
4kode nama
5---------------------------------
682.72.08 Tidore Timur
782.72.08.1001 Mafututu
882.72.08.1002 Tosa
982.72.08.1003 Dowora
1082.72.08.1004 Kalaodi
1182.72.08.1005 Cobodoe
1282.72.08.1006 Doyado
1382.72.08.1007 Jiko Cobo
14
15# 'a%' Finds any values that start with "a"
16# '%a' Finds any values that end with "a"
17# '%or%' Finds any values that have "or" in any position
18# '_r%' Finds any values that have "r" in the second position
19# 'a_%' Finds any values that start with "a" and are at least 2 characters in length
20# 'a__%' Finds any values that start with "a" and are at least 3 characters in length
21# 'a%o' Finds any values that start with "a" and ends with "o"
1SELECT * FROM table_name WHERE UPPER(col_name) LIKE '%SEARCHED%';
2SELECT * FROM table_name WHERE col_name LIKE '%Searched%'; -- Case sensitive
3
4SYMBOL DESCRIPTION (SQL) EXAMPLE
5% zero or more characters bl% 'bl, black, blue, blob'
6_ a single character h_t 'hot, hat, hit'
7[] any single character within brackets h[oa]t 'hot, hat', but NOT 'hit'
8^ any character not in the brackets h[^oa]t 'hit', but NOT 'hot, hat'
9- a range of characters [a-b]t 'cat, cbt'
1-- example
2SELECT Id, ProductName, UnitPrice, Package
3 FROM Product
4 WHERE ProductName LIKE 'Cha_' OR ProductName LIKE 'Chan_'
1eturns true if the operand value matches a pattern.
2Example: Returns true if the user’s first_name ends with ‘son’.
3SELECT * FROM users
4WHERE first_name LIKE '%son';
5
1syntax => SELECT column_name(s)
2FROM table_name
3WHERE column_name LIKE pattern
4////example/////
5///The "%" sign can be used to define wildcards (missing letters in the pattern) both before and after
6the pattern.
7SELECT * FROM Persons
8WHERE City LIKE 's%'