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 vote333 views1 answer
Insensitive case match sqlalchemy
SQL
16 votes342 views4 answers
Ascending order mysql
SQL
0 vote339 views1 answer
OFFSET consulta mysql
SQL
0 vote364 views2 answers
Plpgsql
SQL
0 vote328 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote339 views1 answer
Postgresql concat string with separator
SQL
8 votes317 views1 answer
Alter tablespace add datafile
SQL
5 votes344 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote355 views1 answer
Nodejs sql get one to many relationship as array
SQL
1 vote364 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL