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 vote233 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
4 votes175 views2 answers
REST API
SQL
0 vote195 views1 answer
Postgres can integer fields be negative
SQL
0 vote141 views1 answer
Oracle sql developer script output limit
SQL
0 vote179 views1 answer
Postgres in operator with comma separated values
SQL
0 vote184 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
1 vote195 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
2 votes163 views1 answer
Sql find missing values between two tables
SQL
0 vote179 views1 answer
Call function sql oracle with output put line
SQL
21 votes146 views7 answers
Table drop if exist sql server
SQL