diff options
| author | jhspetersson <jhspetersson@gmail.com> | 2023-12-01 09:28:42 +0100 |
|---|---|---|
| committer | jhspetersson <jhspetersson@gmail.com> | 2023-12-01 09:28:42 +0100 |
| commit | e933427a3b266f9b1319c4de3133065257b95868 (patch) | |
| tree | c909633acb6f420335b22bf6ec651dd07894a7d1 | |
| parent | 16ed137c5f1f2916400fc0b58c5f5f431a97fcf4 (diff) | |
document BETWEEN operator
| -rw-r--r-- | README.md | 1 | ||||
| -rw-r--r-- | docs/usage.md | 1 | ||||
| -rw-r--r-- | src/main.rs | 1 |
3 files changed, 3 insertions, 0 deletions
@@ -112,6 +112,7 @@ Specify file size, get absolute path, and add it to the results: fselect size, abspath from ./tmp where size gt 2g fselect fsize, abspath from ./tmp where size = 5m fselect hsize, abspath from ./tmp where size lt 8k + fselect name, size from ./tmp where size between 5mb and 6mb More complex query: diff --git a/docs/usage.md b/docs/usage.md index 3f9ef55..3b05b68 100644 --- a/docs/usage.md +++ b/docs/usage.md @@ -311,6 +311,7 @@ When you put a directory to search at, you can specify some options. * `!=~` or `!~=` or `notrx` * `like` * `notlike` +* `between` ### Arithmetic operators diff --git a/src/main.rs b/src/main.rs index 2a883e7..d928075 100644 --- a/src/main.rs +++ b/src/main.rs @@ -444,6 +444,7 @@ Expressions: !=~ | !~= | notrx Used to check if the column value doesn't match the regex pattern like Used to check if the column value matches the pattern which follows SQL conventions notlike Used to check if the column value doesn't match the pattern which follows SQL conventions + between Used to check if the column value lies between two values inclusive Logical Operators: and Used as an AND operator for two conditions made with the above operators or Used as an OR operator for two conditions made with the above operators |