Operators

The below table details each operator that is available in the Update Table Rows and Delete Table Rows actions.

Name	SQL Operator	Definition/Use Case
EQ	=	Used to check if two values are exactly equal to each other.
NE	!=	Used to filter for records where two values are not equal.
GT	>	Determines if the left value is strictly greater than the right value.
LT	<	Determines if the left value is strictly less than the right value.
GTE	>=	Checks if a value is either greater than or exactly equal to another value.
LTE	<=	Checks if a value is either less than or exactly equal to another value.
LIKE	LIKE	Used for pattern matching with wildcards (e.g., % for any sequence) and is case-sensitive.
ILIKE	ILIKE	A PostgreSQL-specific operator used for case-insensitive pattern matching.
NOTILIKE	NOT ILIKE	Filters out records that match a case-insensitive pattern.
IS	IS	Primarily used to check for specific states, most commonly IS NULL or IS TRUE.
ISNOT	IS NOT	Used to verify that a value is not in a specific state, such as IS NOT NULL.
IN	IN	Checks if a value matches any value within a specified list or the result of a subquery.
ANY	ANY	Compares a single value against a set of values or an array, returning true if any match is found.