Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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
Comment

SQL is not like

SELECT * FROM Student
WHERE FirstName NOT LIKE '%B%'
Comment

SQL NOT LIKE Operator

SELECT *
FROM Customers
WHERE country NOT LIKE 'USA';
Comment

PREVIOUS NEXT
Code Example
::  
::  
::  
Sql :: mysqldump cli command 
Sql ::  
:: local pg_sql to heroku pg_sql 
::  
Sql :: Write an SQL query to determine the 5th highest salary without using TOP or limit method. 
Sql :: SQL Addition Operator 
::  
Sql :: postgres ERROR: relation "user" does not exist 
:: index in mysql 
::  
Sql :: delete join sql server 
:: compare if is null sql 
::  
Sql :: sql check 
Sql :: SQL Equal to Operator 
:: round decimal mysql 
Sql :: fuck docker mysql 
::  
Sql ::  
::  
:: trigger stock phpmyadmin 
Sql ::  
:: create relationship with betwen two tables in postgersql 
Sql ::  
Sql :: SQLALCHEMY track is set to true or false 
::  
Sql :: oracle archivelog usage 
ADD CONTENT
Topic
Content
Source link
Name
5+7 =