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

4 votes306 views6 answers
Laravel jwt
SQL
1 vote250 views2 answers
Mysql limit offset
SQL
2 votes227 views1 answer
Sql skip the first row
SQL
0 vote186 views1 answer
Oracle tablespace autoextend
SQL
1 vote200 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote208 views1 answer
Postgres reorder columns
SQL
0 vote265 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote194 views1 answer
Sql server check whether column has same equal values
SQL
20 votes205 views4 answers
Reset auto increment in MySQL
SQL
0 vote294 views1 answer
Sql if clause within where clause
SQL