操作函數
更新時間 2025-06-17 10:57:39
最近更新時間: 2025-06-17 10:57:39
分享文章
本文為您介紹DRDS支持的操作函數。
| 函數表達式 | 函數描述 |
|---|---|
| + | Addition operator |
| = | Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) |
| & | Bitwise AND |
| ~ | Bitwise inversion |
| ^ | Bitwise XOR |
| BINARY | Cast a string to a binary string |
| - | Change the sign of the argument |
| NOT | Check whether a value is not within a range of values |
| BETWEEN … | Check whether a value is not within a range of values |
| AND … | Check whether a value is not within a range of values |
| BETWEEN … AND … | Check whether a value is within a range of value |
| STRCMP | Compare two strings |
| / | Division operator |
| = | Equal operator |
| > | Greater than operator |
| >= | Greater than or equal operator |
| DIV | Integer division |
| << | Left shift |
| < | Less than operator |
| <= | Less than or equal operator |
| AND, && | Logical AND |
| OR | Logical OR |
| XOR | Logical XOR |
| - | Minus operator |
| %, | MODModulo operator |
| * | Multiplication operator |
| NOT, ! | Negates value |
| NOT REGEXP | Negation of REGEXP |
| NOT LIKE | Negation of simple pattern matching |
| !=, <> | Not equal operator |
| IS NOT NULL | NOT NULL value test |
| IS NULL | NULL value test |
| <=> | NULL-safe equal to perator |
| REGEXP | Pattern matching using regular expressions |
| Coalesce | Return the fifirst non-NULL argument |
| GREATEST | Return the largest argument |
| LEAST | Return the smallest argument |
| >> | Right shift |
| LIKE | Simple pattern matching |
| RLIKE | Synonym for REGEXP |
| IS NOT | Test a value against a boolean |
| IS | Test a value against a boolean |
