Ausdrücke
prev
next
Inhalt
Blubb
The following expressions should be work on all databases supported by MF
| Name | Supported versions | Example |
|---|---|---|
| a+b | equals | 3+4 |
| a-b | equals | 3-4 |
| a*b | equals | 3*4 |
| a/b | division | 3/4 |
| a BETWEEN b AND c | a in range [b,c] | 5 BETWEEN 2 AND 8 |
| a IN (b,c,...) | a in list | 5 IN (1,2,3,4,5) |
| a LIKE st | a is like pattern (placeholder %) | 'Adam' LIKE 'A%' |
| a=b | equals | "col1"=1 |
| a<>b | not equals | "col1"<>1 |
| a>b | a bigger then b | "col">5 |
| a<b | a smaller than b | "col"<5 |
| a>=b | a bigger or equal to b | "col">=5 |
| a<=b | a smaller or equal to b | "col"<=5 |
| exp AND exp | logical and | "col1"=1 AND "col2"=2 |
| exp OR exp | logical and | "col1"=1 AND "col2"=2 |
| exp XOR exp | logical and | "col1"=1 AND "col2"=2 |
| (exp) | encapsuls exp | "col1"=1 AND ("col2"=2 OR "col3"=3) |