OperatorsΒΆ
The following types of comparaisons are supported by fysql
Operator | Information |
---|---|
== |
x equals y |
!= |
x is not equal to y |
< |
x is less than y |
<= |
x is less or equal to y |
> |
x is greater than y |
>= |
x is greater or equal to y |
<< |
x IN y, where y is a list |
% |
x LIKE y where y may contain wildcards |
.contains(substr) |
Wild-card search for a substring |
.startswith(prefix) |
Search for values beginning with prefix . |
.endswith(suffix) |
Search for values ending with suffix . |
To combine clauses using logical operators use:
Operator | Information | Example |
---|---|---|
& |
AND | (User.id == 1) & (User.username == 'testuser1') |
| |
OR | (User.id == 1) | (User.id == 2) |
~ |
NOT | ~(User.username << ['testuser2','testuser3']) |