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

4 votes303 views1 answer
W3schools create table
SQL
7 votes286 views1 answer
Oracle pagination query offset
SQL
2 votes298 views4 answers
Check timezone of mysql database
SQL
0 vote278 views1 answer
Call rest api from postgresql
SQL
1 vote275 views1 answer
Mysql get character set
SQL
0 vote284 views1 answer
Sql server check whether column has same equal values
SQL
0 vote270 views1 answer
Sql query to delete row by id
SQL
0 vote275 views1 answer
Sql waitfor
SQL
0 vote281 views1 answer
Mysql readable output
SQL
0 vote279 views2 answers
Close external port 3306 with iptables
SQL