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 :: mysql multiply 
Sql :: sql server synonym 
Sql :: snowflake insert select 
Sql :: sql day from datetime 
Sql :: order by postgres 
Sql :: find max number in sql 
Sql :: local pg_sql to heroku pg_sql 
Sql :: how to modify alter user root@localhost identified with mysql_native_password by properly 
Sql :: Write an SQL query to determine the 5th highest salary without using TOP or limit method. 
Sql :: function in sql 
Sql :: psql owner of database 
Sql :: what is 1=2 in sql 
Sql :: select in select sql 
Sql :: sql constraints 
Sql :: desc sql 
Sql :: like operator in sql 
Sql :: stuff and replace in sql 
Sql :: triggers db 
Sql :: sql and or 
Sql :: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client . Can not run php artisan migrate 
Sql :: mysql client onnection error 
Sql :: SQL Server dynamic pivot unknown number of columns 
Sql :: 000webhost database values insert 
Sql :: delete and start from 1 primary key muysql 
Sql :: sqlite3 get data from table c 
Sql :: leftjoin in sql 
Sql :: oracle allow space to user 
Sql :: SQL Views for Complex Queries 
Sql :: postgresql check if role exists 
Sql :: postgres another version 
ADD CONTENT
Topic
Content
Source link
Name
8+2 =