== (equal)
Returns documents where the field is equal to the value

!= (not equal)
Returns documents where the field is not equal to the value

< (less then)
Returns documents where the field is less then the value (should only be used on numeric fields)

> (more then)
Returns documents where the field is more then the value (should only be used on numeric fields)

in
Returns documents where the field is equal to any of the supplied comma separated values.

!in (not in)
Returns documents where the field is not equal to any of the supplied comma separated values.

% (like)
Returns documents where the field contains the supplied value

!% (not like)
Returns documents where the field does not contain the supplied value

%in (like in)
Returns documents where the field contains any of the supplied comma separated values

!%in (not like in)
Returns documents where the field does not contains any of the supplied comma separated values