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