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 vote218 views1 answer
Back up stored procedures mysql
SQL
3 votes219 views1 answer
Sql several or
SQL
-1 vote228 views1 answer
Add column alter table default value
SQL
0 vote238 views1 answer
Python mysql query to dataframe
SQL
0 vote245 views1 answer
R write csv without index
SQL
0 vote236 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote256 views1 answer
Nuget sqllite-net-pcl
SQL
5 votes205 views1 answer
List foreign key oracle
SQL
0 vote212 views1 answer
Zsh: command not found: mysql mamp
SQL
1 vote182 views1 answer
Oracle boolean to varchar
SQL