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

1 vote260 views1 answer
Sql set auto increment back to 0
SQL
1 vote212 views1 answer
Sql auto timestamp
SQL
13 votes230 views2 answers
Sql join
SQL
0 vote241 views1 answer
Alter database name script
SQL
0 vote251 views1 answer
Sqlalchemy one column of two has to be not null
SQL
8 votes245 views3 answers
Oracle auto_increment
SQL
2 votes248 views3 answers
Current setting postgres timezone
SQL
0 vote237 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote244 views1 answer
How to select an index in oracle sql
SQL
0 vote246 views1 answer
Apex for oracle 11g
SQL