Like

Table of Contents



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.


round-pushpin Selects records where the text begins with 'Cat'.
SELECT * FROM WordList:Word WHERE Text Like 'Cat%'

round-pushpin Selects records where the text ends with 'Cat'.
SELECT * FROM WordList:Word WHERE Text Like '%Cat'

round-pushpin Selects records where the text contains 'Cat'.
SELECT * FROM WordList:Word WHERE Text Like '%Cat%'

round-pushpin 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%'


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