Sql is not like

SELECT * FROM emp
  WHERE name NOT LIKE 'a%'			-- not starting with a
  AND name NOT LIKE '%a'			-- not ending with a
  AND name NOT LIKE '%a%'			-- not containing  a
  AND upper(name) NOT LIKE '%A%'	-- not containing  a or A

Similar codes

0 vote189 views1 answer
Mysql find missing values
SQL
13 votes144 views2 answers
Oracle all source
SQL
0 vote244 views1 answer
Sql select merge multiple values
SQL
0 vote205 views1 answer
Criteria builder select subset of column
SQL
11 votes194 views2 answers
Insert current date sql
SQL
3 votes187 views1 answer
Only join in sql
SQL
-1 vote192 views1 answer
Mac mysql workbench console
SQL
0 vote151 views1 answer
Alter session set nls_language french
SQL
1 vote204 views1 answer
Mysql curdate between two dates
SQL
1 vote180 views1 answer
How to use a trigger to validate input data
SQL