Query Language
Reference
The Query Editor supports the following list of operators and parameters.
Comparison Operators
Operator |
Description |
= |
Equal to |
<> |
Not Equal to |
< |
Less than |
> |
Greater than |
<= |
Less than or equal to |
>= |
Greater than or equal to |
IN |
Search in the given list of columns |
NOT IN |
Search in the entire list of columns except those mentioned |
CONTAINS |
Search columns that contain the given list of fields |
LIKE |
Search for a pattern. Search is case sensitive. |
NOT LIKE |
Search for a pattern unlike that is mentioned. Search is case sensitive. |
ILIKE |
Search for a pattern. Search is not case sensitive. |
NOT ILIKE |
Search for a pattern unlike that is mentioned. Search is not case sensitive. |
(+)= |
Left Outer Join Returns all rows in the first table. For no match in the first table, it returns NULL.
You must verify if your database supports this operator. MySQL MaxDB supports this operator. |
=(+) |
Right Outer Join Returns all rows in the second table. For no match in the second table, it returns NULL.
You must verify if your database supports this operator. MySQL MaxDB supports this operator. |
(+)=(+) |
Full Outer Join Returns all rows in the first and the second table. For rows that do not match, it returns NULL.
You must verify if your database supports this operator. MySQL MaxDB supports this operator. |
Logical Operators
Operator |
Description |
AND |
Used in WHERE clause, and displays a row if all conditions listed all true |
OR |
Used in WHERE clause, and displays a row if any condition listed is true |
NOT |
Used in WHERE clause, and displays a row if the negated condition is true |
System Parameters
Parameter Name |
Description |
Syntax |
Login_lang |
Used to find the user’s login language |
:$login_lang |
Special Parameters
Parameter Name |
Description |
Syntax |
Null |
Used to compare a column to a NULL value |
:@null |
This |
Used to refer to the query candidate’s class instance |
:@this |