In this section: |
|
Equal = |
YES |
|
Null safe equal <= > |
No (MySQL engine) |
|
Not equal <> , != |
YES |
|
Less than or equal <= |
YES |
|
Less than < |
YES |
|
Greater than > |
YES |
|
Greater than or equal >= |
YES |
|
IS |
No (MySQL engine) |
|
IS NOT |
No (MySQL engine) |
|
IS NULL |
YES |
|
IS NOT NULL |
YES |
|
BETWEEN … AND … |
YES (except in JOIN conditions) |
|
NOT BETWEEN … AND ... |
YES |
|
COALESCE |
YES |
|
GREATEST |
No (MySQL engine) |
|
IN |
YES |
|
NOT IN |
YES |
|
ISNULL |
YES |
|
INTERVAL |
No (MySQL engine) |
|
LEAST |
No (MySQL engine) |
|
NOT, ! |
YES (except in join conditions) |
|
AND, && |
YES |
|
OR, | | |
YES |
|
XOR |
No (MySQL engine) |
|
ASCII |
YES |
|
BIN |
YES |
|
BIT_LENGTH |
YES |
|
CHAR |
No (MySQL engine) |
|
CHAR_LENGTH |
YES |
|
CHARACTER_LENGTH |
YES |
|
CONCAT |
YES |
|
CONCAT_WS |
YES |
|
CONV |
YES |
|
ELT |
YES |
|
EXPORT_SET |
YES |
|
FIELD |
YES |
|
FIND_IN_SET |
YES |
|
FORMAT |
YES |
|
HEX |
YES |
|
INSTR |
YES |
|
LCASE |
YES |
|
LEFT |
YES |
|
LENGTH |
YES |
|
LOAD_FILE |
No (MySQL engine) |
|
LOCATE |
YES |
|
LOWER |
YES |
|
LPAD |
YES |
|
LTRIM |
YES |
|
MAKE_SET |
YES |
|
MID |
YES |
|
OCT |
YES |
|
OCTET_LENGTH |
YES |
|
ORD |
YES |
|
POSITION |
YES |
|
QUOTE |
YES |
|
REPEAT |
YES |
|
REPLACE |
YES |
|
REVERSE |
YES |
|
RIGHT |
YES |
|
RPAD |
YES |
|
RTRIM |
YES |
|
SOUNDEX |
YES |
|
SOUNDS LIKE |
No (MySQL engine) |
|
SPACE |
YES |
|
SUBSTR |
YES |
|
SUBSTRING |
YES |
|
SUBSTRING_INDEX |
YES |
|
TRIM |
YES |
|
UCASE |
YES |
|
UNHEX |
No (MySQL engine) |
|
UPPER |
YES |
|
Addition ( + ) |
YES |
|
Subtraction ( - ) |
YES |
|
Multiplication ( * ) |
YES |
|
Division ( / ) |
YES |
|
Modulo ( % ) |
YES |
|
ABS |
YES |
|
ACOS |
YES |
|
ASIN |
YES |
|
ATAN2, ATAN |
YES |
|
ATAN |
YES |
|
CEIL |
YES |
|
CEILING |
YES |
|
CONV |
YES |
|
COS |
YES |
|
COT |
YES |
|
DEGREES |
YES |
|
EXP |
YES |
|
FLOOR |
YES |
|
LN |
YES |
|
LOG10 |
YES |
|
LOG2 |
YES |
|
LOG |
YES |
|
MOD |
YES |
|
OCT |
YES |
|
PI |
YES |
|
POW |
YES |
|
POWER |
YES |
|
RADIANS |
YES |
|
RAND |
YES |
|
ROUND |
YES |
|
SIGN |
YES |
|
SIN |
YES |
|
SQRT |
YES |
|
TAN |
YES |
|
TRUNCATE |
YES |
|
ADDDATE |
YES |
|
ADDTIME |
YES |
|
CURDATE |
YES |
|
CURRENT_DATE |
YES |
|
CURRENT_TIME |
YES |
|
CURRENT_TIMESTAMP |
YES |
|
CURTIME |
YES |
|
DATE |
YES |
|
DATEDIFF |
YES |
|
DATE_ADD |
YES |
|
DATE_FORMAT |
YES |
|
DATE_SUB |
YES |
|
DAY |
YES |
|
DAYNAME |
YES |
|
DAYOFMONTH |
YES |
|
DAYOFWEEK |
YES |
|
DAYOFYEAR |
YES |
|
EXTRACT |
YES |
|
FROM_DAYS |
No (MySQL engine) |
|
FROM_UNIXTIME |
YES |
|
GET_FORMAT |
No (MySQL engine) |
|
HOUR |
YES |
|
LAST_DAY |
No (MySQL engine) |
|
LOCALTIME |
YES |
|
LOCALTIMESTAMP |
YES |
|
MAKEDATE |
No (MySQL engine) |
|
MAKETIME |
No (MySQL engine) |
|
MICROSECOND |
No (MySQL engine) |
|
MINUTE |
YES |
|
MONTH |
YES |
|
MONTHNAME |
YES |
|
NOW |
YES |
|
PERIOD_ADD |
YES |
|
PERIOD_DIFF |
YES |
|
QUARTER |
YES |
|
SECOND |
YES |
|
SEC_TO_TIME |
No (MySQL engine) |
|
STR_TO_DATE |
No (MySQL engine) |
|
SUBDATE |
YES |
|
SUBTIME |
YES |
|
SYSDATE |
YES |
|
TIME |
YES |
|
TIMEDIFF |
YES |
|
TIMESTAMP |
No (MySQL engine) |
|
TIMESTAMPADD |
No (MySQL engine) |
|
TIMESTAMPDIFF |
No (MySQL engine) |
|
TIME_FORMAT |
YES |
|
TIME_TO_SEC |
No (MySQL engine) |
|
TO_DAYS |
YES |
|
UNIX_TIMESTAMP |
YES |
|
UTC_DATE |
YES |
|
UTC_TIME |
YES |
|
UTC_TIMESTAMP |
No (MySQL engine) |
|
WEEK |
YES |
|
WEEKDAY |
No (MySQL engine) |
|
WEEKOFYEAR |
No (MySQL engine) |
|
YEAR |
No (MySQL engine) |
|
YEARWEEK |
YES |
|
BINARY |
No (MySQL engine) |
|
CAST |
YES |
|
CONVERT |
YES |
|
MATCH |
No (MySQL engine) |
|
Bit Functions |
No (MySQL engine) |
|
Encryption, Compression Functions |
No (MySQL engine) |
|
Information Functions |
No (MySQL engine) |
|
AVG |
YES |
|
BIT_OR |
No (MySQL engine) |
|
BIT_AND |
No (MySQL engine) |
|
BIT_XOR |
No (MySQL engine) |
|
COUNT |
YES |
|
GROUP_CONCAT |
No (MySQL engine) |
|
MIN |
YES |
|
MAX |
YES |
|
STD, STDDEV |
YES |
|
STDDEV_POP |
YES |
|
STDDEV_SAMP |
YES |
|
SUM |
YES |
|
VAR_POP |
YES |
|
VAR_SAMP |
YES |
|
VARIANCE |
YES |
| WebFOCUS |