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 vote236 views1 answer
Oracle last connexion
SQL
0 vote245 views1 answer
Savepoint mysql script
SQL
22 votes227 views4 answers
Tsql rename table
SQL
8 votes232 views5 answers
Grant permission in postgres
SQL
0 vote223 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote215 views2 answers
Find Overlapping sql
SQL
3 votes230 views1 answer
Query less than datetime sql
SQL
1 vote216 views1 answer
Apex run 404
SQL
5 votes215 views2 answers
Update all rows mysql
SQL
0 vote245 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL