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:

• underscore (_) match any one character;

• percent (%) match any string of 0 or more characters;

• back slash (\) prevent a wild card from having its special meaning;

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.