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 vote140 views1 answer
Mysql show current queries
SQL
0 vote146 views1 answer
Mysql export search results
SQL
0 vote147 views1 answer
Drop specific row postgresql
SQL
2 votes139 views1 answer
Mysql sysdate
SQL
0 vote151 views1 answer
Plpgsql raise notice
SQL
1 vote158 views2 answers
Restart identity cascade
SQL
0 vote147 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote134 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote134 views2 answers
Postgresql create role
SQL
0 vote165 views1 answer
Pl/pgsql declare variable
SQL