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

11 votes97 views2 answers
Having clause
SQL
3 votes112 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote95 views1 answer
Create new table pl sql
SQL
0 vote107 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote106 views1 answer
Mysql grant grant option
SQL
0 vote107 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote107 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
1 vote113 views1 answer
Table valued functions in sql
SQL
0 vote97 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
1 vote85 views1 answer
Mysql see column types
SQL