...

If the user inputs "*key*" or "*key", the like statement becomes "like %key%". 

VERY EXPENSIVE (expand on this)A Like filter is very expensive, so be wary using this Comparison Type, as it may result in very slow searches.

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".

...