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 vote188 views1 answer
Sql from null to not null
SQL
7 votes185 views4 answers
Database dump mysql command
SQL
5 votes191 views1 answer
How to get all table names in sql query
SQL
1 vote201 views1 answer
Top 10 rows in mysql
SQL
22 votes160 views3 answers
SQL CHEATSHEET
SQL
4 votes121 views2 answers
Select todays data postgres query
SQL
0 vote168 views1 answer
Create table using the clause with as
SQL
0 vote195 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
1 vote185 views2 answers
Copy table in sql
SQL
0 vote156 views1 answer
How to get inserted id in sql server
SQL