Skip to main content
OCLC

Query operators

Operator Description
Equal to Limits results set returned to all operands that are an exact match to the condition's object.
Not Equal to Limits results set returned to all operands that are not an exact match to the condition's objects.
In List Limits results set to any and all values in a list of values.
Not In List Limits results set to any and all values not in a list of values.
Between Limits results set returned to any and all values between two operands.
Not Between Limits results set returned to any and all values outside the values of two operands.
Greater than Limits results set returned to all operands that have a value greater than that of the condition's object.
Greater than or Equal to Limits results set returned to all operands that have a value greater than or equal to that of the condition's objects.
Less than Limits results set returned to all operands that have a value less than that of the condition's object.
Less than or Equal to Limits results set returned to all operands that have a value less than or equal to that of the condition's objects.
Matches pattern Limits results set to any and all values that match a pattern.
Different from pattern Limits results set to any and all values that does not match a pattern.
Both Limits results set to both values used as an operand.
Except Limits results set to the exception of values used as an operand.
Is Null Not used at OCLC.
Is not Null Not used at OCLC.
  • Was this article helpful?