...

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

VERY EXPENSIVE (expand on this)

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

...