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 vote292 views1 answer
Sql server set complex constraints
SQL
0 vote319 views1 answer
Mysqldump: error:
SQL
0 vote302 views1 answer
Python list from sql
SQL
2 votes301 views1 answer
Flask sqlalchemy boolean field
SQL
1 vote273 views1 answer
T-SQL Alter the column data type
SQL
0 vote273 views1 answer
Mysql_num_fields in mysqli
SQL
3 votes278 views1 answer
Convert sqlite table to pandas dataframe
SQL
1 vote275 views2 answers
Sql groub by count
SQL
2 votes306 views1 answer
Mysql increment value by 1 in update
SQL
0 vote294 views1 answer
Create function in microsoft sql server
SQL