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 vote368 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote403 views1 answer
GROUP BY postgres
SQL
2 votes389 views2 answers
Postgres timestamp to datetime
SQL
1 vote369 views1 answer
How to see which columns are indexxed mysql
SQL
2 votes366 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote378 views1 answer
Sql date between one week
SQL
0 vote364 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote298 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
1 vote383 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
6 votes359 views2 answers
Clear a table in mysql
SQL