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 vote190 views1 answer
List column names of multiple tables psql
SQL
4 votes197 views1 answer
Refresh postgres config
SQL
0 vote201 views1 answer
How to check replication lag in mySQL
SQL
5 votes216 views1 answer
Oracle list functions
SQL
0 vote192 views1 answer
Postgres enumerated type
SQL
18 votes217 views3 answers
Mysql add column default value
SQL
0 vote260 views1 answer
Fetching data from mysqldb
SQL
0 vote236 views1 answer
Set mysql socket file docker windows
SQL
0 vote203 views1 answer
Vbscript clean up ADODB.Recordset
SQL
2 votes182 views2 answers
Postgresql date at timezone
SQL