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
SELECT * FROM Student
WHERE FirstName NOT LIKE '%B%'
SELECT *
FROM Customers
WHERE country NOT LIKE 'USA';
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 |