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

2 votes352 views1 answer
Sql skip the first row
SQL
0 vote361 views1 answer
WHERE not regex in SQL
SQL
-2 votes351 views3 answers
Oracle tablespace usage
SQL
0 vote315 views2 answers
Delete the last item in a table sql
SQL
1 vote330 views1 answer
Select random sample sql
SQL
2 votes366 views2 answers
Created at and updated at in mysql
SQL
16 votes351 views4 answers
Mysql import from sql file
SQL
1 vote356 views2 answers
Login to mysql
SQL
0 vote367 views1 answer
Creating a simple notify in postgresql
SQL
0 vote374 views1 answer
Sql select lowest value row
SQL