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

10 votes268 views1 answer
Dba_dependencies
SQL
9 votes297 views6 answers
Replace sql
SQL
-1 vote280 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote282 views1 answer
Incorrect string value: mysql
SQL
0 vote290 views1 answer
Mysql count unique in group statement
SQL
0 vote283 views1 answer
Oracle sql procedure return value
SQL
0 vote283 views1 answer
Opensuse stop MySQL
SQL
0 vote285 views1 answer
Get the previous column of a table in mysql
SQL
0 vote296 views1 answer
Change magento database url usimg musql
SQL
0 vote287 views1 answer
Alter database name script
SQL