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 |