picoSQL - Language reference manual

6.4) LIKE predicate

LIKE predicate allows to search some string data using wild cards. The syntax is:

string-expression [NOT] LIKE pattern

The pattern may contain any number of wild cards. The wild cards are:

For example, the pattern 'B%' corresponds to any value starting with the B character, while the pattern 'B__' corresponds any value starting with the B character and three characters long.

NOT operator reverses the meaning of the condition.

Index Previous Next