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 vote263 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
1 vote191 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
1 vote234 views1 answer
Oracle drop chain step
SQL
1 vote199 views1 answer
Sql current timestamp
SQL
0 vote204 views2 answers
Transaction php
SQL
2 votes189 views2 answers
Mysql limit
SQL
0 vote184 views1 answer
Add column to table with default value plsql
SQL
11 votes224 views3 answers
Change column name sql server management studio
SQL
1 vote178 views1 answer
Hexadec to sql REDSHIFT
SQL
0 vote231 views1 answer
How to create notes in mysql
SQL