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

1 vote184 views1 answer
Postgres grant read only access to database
SQL
5 votes231 views1 answer
Oracle get foreign keys on table
SQL
19 votes216 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote216 views1 answer
How to convert DateTime to VarChar SQL
SQL
1 vote224 views1 answer
Size of all tables in a schema oracle
SQL
10 votes227 views1 answer
Oracle object dependencies
SQL
27 votes239 views6 answers
Sql update record
SQL
1 vote218 views1 answer
Mysql view command
SQL
0 vote221 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote184 views1 answer
How to see the content of tables in pgadmin
SQL