...
Filters out any results, which does match any of the supplied parameters.
Example:
If a user inputs "pink" and "kitten" then the "pink fluffy sith lord" asset will be filtered out, because one of its keywords is "pink".
Like
...
/LikeAutoAsterixing
Works almost exactly like the SQL "like" operator.
The easiest way to understand the differences is with a brief example:
The filter:
If the user inputs a parameter with value "key", the final like statement is "like 'key%", ie any meta fields, which does not have a name starting with "key", are filtered out.
If the user inputs "*key*" or "*key", the like statement becomes "like %key%".
Between
"Between" is a very specific Comparison Type: it can only be used with filters, which does work on dates or DateTimes, eg "asset.start_date" and "asset.end_date".
...