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 vote185 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
-1 vote172 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
2 votes170 views1 answer
Oracle index size calculation
SQL
0 vote160 views1 answer
Min salary in sql
SQL
0 vote172 views1 answer
Mysql date only no time
SQL
2 votes169 views1 answer
Mysql sysdate
SQL
0 vote233 views1 answer
Mysql get longest string in column
SQL
0 vote180 views1 answer
Get date from timestamp in mysql
SQL
4 votes239 views2 answers
Delete all table oracle
SQL
2 votes198 views1 answer
Find column in all stored procedures sql server
SQL