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 vote183 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
8 votes188 views2 answers
Alert table name mysql
SQL
10 votes190 views5 answers
Between keyword in sql
SQL
25 votes223 views6 answers
Import database mysql command line
SQL
10 votes187 views1 answer
Query to find object dependencies in oracle
SQL
8 votes210 views1 answer
Mysql restore database
SQL
10 votes181 views4 answers
Primary key in sql
SQL
0 vote214 views10 answers
Sql statement checker corrector
SQL
1 vote198 views1 answer
Sql select row with max date
SQL
0 vote187 views2 answers
Connect to mysql server mac terminal
SQL