How is the LIKE operator supported inside DESelect Segment?

The SQL LIKE operator is used in filters with the begins with, ends with, contains, and does not contain criteria.

Example: You would like to query contacts with an email from a particular domain. The full details on how to achieve this in DESelect can be found here.