Like sql

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 3 characters in length
WHERE ContactName LIKE 'a%o'	
--Finds any values that start with "a" and ends with "o"

103

Similar codes

0 vote359 views1 answer
Select * where id = 1,2,3
SQL
1 vote413 views1 answer
Sql select row with max date
SQL
4 votes322 views2 answers
Oracle set date format
SQL
0 vote395 views1 answer
Oracle pl/sql check if file exists
SQL
2 votes331 views1 answer
Postgresql add entry to table
SQL
0 vote352 views1 answer
Django how to get query result count
SQL
11 votes380 views2 answers
Oracle saurce code
SQL
8 votes334 views2 answers
Mysql query dates between two dates
SQL
14 votes421 views1 answer
How to export db from mysql
SQL
8 votes390 views1 answer
See all users mysql
SQL