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

10 votes214 views2 answers
Forgot my mysql password mac
SQL
0 vote262 views3 answers
How to find all role in mysql
SQL
0 vote209 views1 answer
Sql auto_increment syntax
SQL
0 vote213 views1 answer
Get id if is not equal in certain table
SQL
0 vote249 views1 answer
Dual in db2
SQL
38 votes217 views4 answers
Count sql
SQL
0 vote199 views1 answer
Mysql percentage of total
SQL
-1 vote207 views2 answers
Full join sql
SQL
1 vote220 views1 answer
Mysql query bulk insert
SQL
3 votes282 views1 answer
Mysql cli connect with password
SQL