Logical Connectors

Table of Contents



AND and OR connect conditions in Where clauses and join ON conditions. Conditions can be grouped with any number of nested parentheses, and are evaluated using the standard order of operations (AND before OR).

round-pushpin Selects words where the text is either 'Cat' or 'Dog'.
SELECT * FROM WordList:Word
WHERE Text = 'Cat' OR Text = 'Dog'

round-pushpin Selects words that start with 'Cat' and whose LanguageId is either 3 or 1.
SELECT * FROM WordList:Word
WHERE Text LIKE 'Cat%' AND (LanguageId = 3 OR LanguageId = 1)


SQL :: Delete
Delete removes the documents that match the given criteria.
SQL :: Expressions
Literals, operators, comments and variables in KBSQL.
SQL :: Keywords
A breakdown of all of the statements and keywords supported by the query processor.
SQL :: Select
Select statements are used to read (or query) data from the database.
SQL :: Update
Update changes fields of existing documents.
SQL :: Where
The where clause filters the documents read, updated or deleted by a statement.