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 vote237 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote226 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote204 views1 answer
Mysql a from on this page has
SQL
0 vote198 views1 answer
Azure sql server check foreign key
SQL
2 votes194 views2 answers
Sql strip non alphanumeric characters
SQL
7 votes216 views2 answers
Phpmyadmin change password
SQL
0 vote177 views1 answer
Order by with where clause in mysql
SQL
0 vote207 views1 answer
Sql with example
SQL
2 votes174 views1 answer
Oracle sql drop column if exists
SQL
0 vote200 views1 answer
Python connect to mysql in settings.py
SQL