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 vote123 views1 answer
Command line mysql xampp
SQL
0 vote108 views1 answer
Oracle c# multiple update sql
SQL
6 votes93 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
36 votes227 views6 answers
Change column data type sql
SQL
1 vote95 views1 answer
Mysql best tutorial for beginners
SQL
5 votes104 views3 answers
Mysql check if null or empty string
SQL
0 vote101 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
2 votes110 views1 answer
Create mysql user on all hosts
SQL
19 votes104 views6 answers
Laravel sql query
SQL
0 vote96 views1 answer
Get first name and last name from full name string in SQL
SQL