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 vote144 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote171 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote166 views1 answer
How to find top 3 salary in sql
SQL
0 vote142 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote160 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
1 vote154 views2 answers
Copy database mysql
SQL
2 votes140 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote151 views1 answer
Postgres sequence name
SQL
20 votes143 views2 answers
Counting in sql
SQL
0 vote156 views2 answers
Postgresql variable in query
SQL