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 vote282 views1 answer
Mysqlimport
SQL
3 votes275 views2 answers
Having in mysql
SQL
4 votes308 views1 answer
For loop postgresql
SQL
1 vote288 views1 answer
How to check the mysql version mac
SQL
0 vote305 views1 answer
Mysql query to select the highest value
SQL
1 vote312 views1 answer
Psql connect
SQL
1 vote287 views1 answer
Change table to innodb mysql
SQL
4 votes296 views1 answer
Sql any
SQL
0 vote285 views1 answer
Hive batch drop table
SQL
0 vote312 views1 answer
Normalization in database
SQL