Not

Table of Contents



The NOT keyword performs a not operation on logical operators such as LIKE and BETWEEN, allowing a query to exclude data that does not fall within given ranges


round-pushpin Selects records where the text does not begin with 'Cat'.
SELECT * FROM WordList:Word WHERE Text NOT LIKE 'Cat'

round-pushpin Selects records where the Id does not begin fall between a given range.
SELECT * FROM WordList:Word WHERE Id NOT BETWEEN 0 AND 600010




SQL :: Between
The between keyword allows a query to retrieve data that falls within a given range.
SQL :: Like
Allows for basic pattern matching in a where clause.
SQL::Keywords
A breakdown of all high-level statements available via the query handler.