Find operators
You can use the following operators in Find mode. The only operator supported by quick find is double quotation marks (" ").
Operator |
Description |
= |
match whole word (or match empty) |
== |
match entire field |
! | find duplicate values |
< | less than |
<= | less than or equal to |
> | greater than |
>= | greater than or equal to |
... | range |
// | today's date |
? | invalid date or time |
@ | any one character |
# | any one digit |
* | zero or more characters |
\ | escape next character |
"" | match phrase (from word start) |
*"" | match phrase (from anywhere) |
~ | relaxed search (Japanese only) |