MySQL
Table of Contents
Classes
- Acos
- Asin
- Atan
- Atan2
- Binary
- "BINARY" "(" stringPrimary ")"
- CharLength
- "CHAR_LENGTH" "(" SimpleArithmeticExpression ")"
- ConcatWs
- Usage: CONCAT_WS(SEPARATOR, STR1, STR2, ... [ NOTEMPTY ])
- ConvertTz
- DateFunction ::= "CONVERT_TZ" "(" ArithmeticPrimary "," StringPrimary "," StringPrimary ")"
- Cos
- Cot
- CountIf
- Usage: COUNTIF(expr1, expr2 [ INVERSE ])
- Crc32
- "CRC32" "(" StringPrimary ")"
- Date
- "DATE" "(" SimpleArithmeticExpression ")".
- DateAdd
- DateDiff
- DateFormat
- Day
- "DAY" "(" SimpleArithmeticExpression ")". Modified from DoctrineExtensions\Query\Mysql\Year
- Degrees
- Field
- Usage: FIELD(str,str1,str2,str3,...)
- FindInSet
- GroupConcat
- Hour
- "HOUR" "(" SimpleArithmeticExpression ")".
- IfElse
- Usage: IF(expr1, expr2, expr3)
- IfNull
- Usage: IFNULL(expr1, expr2)
- JsonExtract
- MatchAgainst
- MatchAgainstFunction ::=
"MATCH" "(" StateFieldPathExpression {"," StateFieldPathExpression}* ")" "AGAINST" "("
StringPrimary ["BOOLEAN"] ["EXPAND"] ")"
- Md5
- "MD5" "(" StringPrimary ")"
- Month
- "MONTH" "(" SimpleArithmeticExpression ")". Modified from DoctrineExtensions\Query\Mysql\Year
- NullIf
- Usage: NULLIF(expr1, expr2)
- Pi
- Power
- Radians
- Rand
- Mysql RAND() implementation for Doctrine2
- Regexp
- Round
- Sha1
- "SHA1" "(" StringPrimary ")"
- Sha2
- "SHA2" "(" StringPrimary "," SimpleArithmeticExpression ")"
- Sin
- StrToDate
- Tan
- TimestampDiff
- Usage: TIMESTAMPDIFF(unit, expr1, expr2)
- Week
- "WEEK" "(" SimpleArithmeticExpression " [, " Literal "])". Modified from DoctrineExtensions\Query\Mysql\Year
- Year
- "YEAR" "(" SimpleArithmeticExpression ")"