Mautic Community Forums

Difference between Like operator and Equal

What is the difference between Like operator and Equal operator ?

What is the difference between Like operator and Equal operator ?

AS per my understanding a LIKE is like an include ?
I am asking this because why I try to do is to sort email address based on what is after the @
example I want to put in a segment all email with @gmail.com
Do i undestand well that I should use LIKE @gmail.com for sorting email instead of EQUAL @gmail.com ?

Hi @laurentm , that’s a good question actually :slight_smile: and the correct answer is to use the % as a wildcard character. so you would use %@gmail.com as the value to find all gmail contacts in the filter and then run, via cron, php appconsole mautic:segments:update for it to find all the matches from your contacts and add them to your segment. You can also just use email:%@gmail.com in the contacts filter to preview / verify the results.