picoSQL - Language reference manual
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.