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

3 votes220 views2 answers
Oracle sql first day of month
SQL
0 vote160 views1 answer
Sql query for displaying age from oldest to youngest
SQL
9 votes170 views2 answers
Sql limit to 5 results
SQL
6 votes168 views2 answers
Foreign key sqlite3 python
SQL
0 vote168 views1 answer
Template MySQL Zabbix agent
SQL
0 vote182 views1 answer
Postgresql cast as year and month from timestamp
SQL
8 votes171 views1 answer
Check mysql version phpmyadmin
SQL
0 vote190 views1 answer
Sql alter column name sql server
SQL
1 vote148 views1 answer
Mysql get character set
SQL
0 vote157 views1 answer
Sql query to force the database to be drop
SQL