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

3 votes130 views1 answer
Sql select second max
SQL
0 vote103 views1 answer
Sql server bool select
SQL
8 votes111 views1 answer
Mysql limit rows
SQL
0 vote108 views1 answer
Left join in codeigniter query builder
SQL
10 votes119 views6 answers
Sql between
SQL
0 vote100 views1 answer
List all permissions on a table in postgres
SQL
5 votes119 views2 answers
Mysql dump mysql db cli
SQL
5 votes98 views2 answers
Oracle timestamp to date
SQL
2 votes99 views1 answer
Sql server find table name
SQL
24 votes109 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL