Like Operator
The Like operator is similar to Between.
Example:
SELECT pop FROM table WHERE state LIKE 'M%'
If the data source provider supports LIKE, the entire query is delegated to the data source provider.
If the data source provider does not support LIKE, only part of the query is delegated:
SELECT state, pop FROM table
Spectrum Spatial executes the entire query, using the results from the data provider:
SELECT pop FROM <results from the delegation> WHERE state like 'M%'