Navicat MySQL Administrator download for Windows

Click on the filter operator box (next to the column box) and select contains item from the dropdown list which displaying all available filter operators.

Filter Operator	Result
is equal to <?>	My_Field = 'your_value'
is not equal to <?>	My_Field <> 'your_value'
is less than <?>	My_Field < 'your_value'
is less than or equal to <?>	My_Field <= 'your_value'
is greater than <?>	My_Field > 'your_value'
is greater than or equal to <?>	My_Field >= 'your_value'
contain <?>	My_Field LIKE '%your_value%'
does not contain <?>	NOT (My_Field LIKE '%your_value%')
begin with <?>	My_Field LIKE 'your_value%'
end with <?>	My_Field LIKE '%your_value'
is null	My_Field IS NULL
is not null	My_Field IS NOT NULL
is empty	My_Field = ''
is not empty	My_Field <> ''
is between <?> <?>	((My_Field >= your_value1) and (My_Field <= your_value2))
is not between <?> <?>	NOT ((My_Field >= your_value1) and (My_Field <= your_value2))
is in list <?>	My_Field in ('aaa','bbb',...)
is not in list <?>	My_Field not in ('aaa','bbb',...)