Like

Table of Contents

Overview
The LIKE statement allows for basic pattern matching in a where clause. Use the following to manipulate the patern matching.

% percent wildcard matches zero, one, or more characters
_ underscore wildcard matches a single character.

Selects records where the text begins with 'Cat'.

SELECT * FROM WordList:Word WHERE Text Like 'Cat%'

Selects records where the text ends with 'Cat'.

SELECT * FROM WordList:Word WHERE Text Like '%Cat'

Selects records where the text contains 'Cat'.

SELECT * FROM WordList:Word WHERE Text Like '%Cat%'

Selects records where the text contains a 3 letter sequence that begins with 'C' and ends with 't'.

SELECT * FROM WordList:Word WHERE Text Like '%C_t%'

Not - The NOT keyword performs a not operation on logical operators such as LIKE and BETWEEN.
Keywords - A breakdown of all high-level statements available via the query handler.