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

36 votes143 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote187 views1 answer
Sql select without column name
SQL
4 votes175 views3 answers
Postgres drop all tables
SQL
3 votes113 views2 answers
Coalesce mysql
SQL
0 vote153 views1 answer
Postgresql custom order by
SQL
0 vote135 views3 answers
Postgres trim string
SQL
4 votes164 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote154 views2 answers
Return the number of records in a single table mysql
SQL
0 vote168 views1 answer
Postgres get database encoding
SQL
0 vote158 views1 answer
Postgresql function ROUND
SQL