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 vote183 views1 answer
Oracle current sequence value
SQL
0 vote101 views1 answer
T-sql email validation
SQL
0 vote110 views1 answer
List all indexes postgres
SQL
2 votes107 views2 answers
How to check database username and password in postgresql
SQL
0 vote71 views1 answer
Import sql file in mysql linux
SQL
0 vote135 views1 answer
Create table with timestamp mysql youtube
SQL
8 votes106 views5 answers
Grant permission in postgres
SQL
18 votes99 views3 answers
Mysql query add column with default string value
SQL
0 vote59 views1 answer
Oracle list all stored procedures
SQL
51 votes214 views6 answers
Opera gx
SQL