Relational Operators in QBE

Relational operators in QBE are comparison operators that allows you to evaluate or check the relationship between two values, returning a Boolean result which allows filtering, searching or sorting the data in your queries.

GraphQL QBE Relational Operator	Equivalent SQL Operator
_eq and _ne	Equivalent to ‘=’ and ‘!=’.
_lt and _lte	Equivalent to ‘<’ and ‘<=’.
_gt and _gte	Equivalent to ‘>’ and ‘>=’.
_like and _nlike	Equivalent to ‘like’ and ‘not like’.
_is_null	Equivalent to ‘where <field> is null’. Example - Office: {_is_null: TRUE}
_in, _nin, and _between	Equivalent to IN, NOT IN, and BETWEEN

• Equal and Not Equal to QBE Operators
  Learn to use QBE operators _eq, and _ne to filter specific data from the car racing dataset through simple examples.

• Greater and Less than QBE Operators
  Learn to use QBE operators _gt, _gte, _lt and _lte to filter specific data from the car racing dataset through simple examples.

• LIKE and NOT LIKE QBE Operators
  Learn to use the _like and _nlike QBE operators to filter specific data from the car racing dataset through simple examples.

• IS NULL QBE Operator
  Learn to use the _is_null QBE operator to filter specific data from the car racing dataset through simple examples.

• IN, NOT IN and BETWEEN QBE Operators
  Learn to use QBE operators _in, _nin, and _between to filter specific data from the car racing dataset through simple examples.