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 vote328 views1 answer
Cannot pip install mysqlclient
SQL
-1 vote298 views1 answer
Adding a new table psql
SQL
7 votes306 views3 answers
Restore postgres database from sql file
SQL
1 vote345 views2 answers
Truncate table sqlite
SQL
0 vote304 views1 answer
Import sql dump into postgresql database
SQL
0 vote365 views2 answers
Sql query print strings and int
SQL
1 vote302 views1 answer
Pv mysql import
SQL
11 votes312 views3 answers
Change column name sql server management studio
SQL
5 votes290 views1 answer
Update sql user password
SQL
0 vote308 views1 answer
Day of the week sqlite
SQL