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 vote346 views1 answer
Mysql random number between 1 and 100
SQL
0 vote348 views1 answer
Doctors appointment
SQL
0 vote447 views1 answer
Postgresql powershell query
SQL
1 vote321 views1 answer
Check if mysql is installed
SQL
-1 vote321 views1 answer
Sql set max value in column
SQL
3 votes324 views1 answer
Oracle apex call duration
SQL
1 vote337 views2 answers
Logical operators in sql
SQL
0 vote271 views1 answer
Postgresql add leading zeros
SQL
0 vote319 views1 answer
Mysql concat and use as where column
SQL
1 vote337 views3 answers
How to truncate table with foreign key constraint
SQL