Like in mysql

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

Like in mysql

SELECT name FROM products WHERE name LIKE '%Value1' OR name LIKE '%Value2';

Similar codes

0 vote188 views1 answer
Mysql random number between 1 and 100
SQL
0 vote199 views1 answer
How to update date value in sql
SQL
0 vote163 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
1 vote202 views2 answers
Drop table with constraints
SQL
2 votes161 views1 answer
When matched in sql server
SQL
3 votes282 views2 answers
Oracle sql first day of month
SQL
0 vote179 views1 answer
Declarative base sqlalchemy
SQL
4 votes180 views2 answers
Oracle sql group by date year
SQL
1 vote167 views1 answer
Delete row mssql
SQL
0 vote166 views1 answer
Get week day name sql server
SQL