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

2 votes279 views5 answers
Install postgresql 10 centos 7
SQL
5 votes314 views1 answer
Oracle source query
SQL
2 votes273 views2 answers
Spring where to put the data sql
SQL
25 votes291 views1 answer
How to update an attribute in MySQL
SQL
0 vote278 views4 answers
Open mysql port bitnami tomact
SQL
1 vote259 views3 answers
Psql fatal database does not exist
SQL
3 votes269 views1 answer
Postgresql db owner change
SQL
0 vote257 views1 answer
Bigquery declare
SQL
0 vote263 views1 answer
Reset postgresql password windows
SQL
0 vote294 views2 answers
Oracle chain rules
SQL