• SQL Functions Mapping to Other Databases
• Numeric Functions
  • ABS
  • ACOS
  • ASIN
  • ATAN
  • ATAN2
  • CEILING
  • CONV
  • COS
  • COT
  • CRC32
  • DEGREES
  • DIV
  • EXP
  • FLOOR
  • LN
  • LOG10
  • LOG2
  • LOG
  • MOD
  • PI
  • POWER
  • RADIANS
  • RAND
  • ROUND
  • SIGN
  • SIN
  • SQRT
  • TAN
  • TRUNCATE
• String Functions
  • ASCII
  • BIN
  • BIT_COUNT
  • BIT_LENGTH
  • CHAR_LENGTH
  • CHAR
  • CONCAT_WS
  • CONCAT
  • ELT
  • EXPORT_SET
  • FIELD
  • FIND_IN_SET
  • INSERT
  • INSTR
  • LEFT
  • LENGTH
  • LOCATE
  • LOWER
  • LPAD
  • LTRIM
  • MAKE_SET
  • OCT
  • OCTET_LENGTH
  • ORD
  • QUOTE
  • REGEXP
  • REPEAT
  • REPLACE
  • REVERSE
  • RIGHT
  • RPAD
  • RTRIM
  • SOUNDEX
  • SPACE
  • STRCMP
  • SUBSTR
  • SUBSTRING_INDEX
  • TRIM
  • UPPER
  • WEIGHT_STRING
• Date and Time Functions
  • ADDDATE
  • ADDTIME
  • CONVERT_TZ
  • CURDATE
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • CURTIME
  • DATE_ADD
  • DATE_FORMAT
  • DATE_SUB
  • DATE
  • DATEDIFF
  • DAY
  • DAYNAME
  • DAYOFMONTH
  • DAYOFWEEK
  • DAYOFYEAR
  • EXTRACT
  • FROM_DAYS
  • FROM_UNIXTIME
  • GET_FORMAT
  • HOUR
  • LAST_DAY
  • LOCALTIME
  • LOCALTIMESTAMP
  • MAKEDATE
  • MAKETIME
  • MICROSECOND
  • MINUTE
  • MONTH
  • MONTHNAME
  • NOW
  • PERIOD_ADD
  • PERIOD_DIFF
  • QUARTER
  • SEC_TO_TIME
  • SECOND
  • STR_TO_DATE
  • SUBDATE
  • SUBTIME
  • SYSDATE
  • TIME_FORMAT
  • TIME_TO_SEC
  • TIME
  • TIMEDIFF
  • TIMESTAMP
  • TIMESTAMPADD
  • TIMESTAMPDIFF
  • TO_DAYS
  • UNIX_TIMESTAMP
  • UTC_DATE
  • UTC_TIME
  • UTC_TIMESTAMP
  • WEEK
  • WEEKDAY
  • WEEKOFYEAR
  • YEAR
  • YEARWEEK
• Analitic and Aggregate Functions
  • AVG
  • BIT_AND
  • BIT_OR
  • BIT_XOR
  • COUNT(DISTINCT)
  • COUNT
  • GROUP_CONCAT
  • MAX
  • MIN
  • STD
  • STDDEV_POP
  • STDDEV_SAMP
  • STDDEV
  • SUM
  • VAR_POP
  • VAR_SAMP
  • VARIANCE
• Conversion Functions
  • BINARY
  • CAST
  • Convert
  • AES_DECRYPT
  • AES_ENCRYPT
  • COMPRESS
  • UNCOMPRESS
  • UNCOMPRESSED_LENGTH
  • DECODE
  • DES_DECRYPT
  • DES_ENCRYPT
  • ENCODE
  • ENCRYPT
  • FORMAT
  • HEX
  • UNHEX
• XML Functions
  • ExtractValue
  • UpdateXML
• Environment and System Functions
  • BENCHMARK
  • CHARSET
  • COERCIBILITY
  • COLLATION
  • CONNECTION_ID
  • CURRENT_USER
  • DATABASE
  • DEFAULT
  • FOUND_ROWS
  • GET_LOCK
  • INET_ATON
  • INET_NTOA
  • IS_FREE_LOCK
  • IS_USED_LOCK
  • LAST_INSERT_ID
  • MASTER_POS_WAIT
  • NAME_CONST
  • RELEASE_LOCK
  • ROW_COUNT
  • SCHEMA
  • SESSION_USER
  • SLEEP
  • SYSTEM_USER
  • USER
  • UUID
  • UUID_SHORT
  • VALUES
  • VERSION
  • OLD_PASSWORD
  • PASSWORD
• Other Functions
  • CASE
  • IF
  • IFNULL
  • NULLIF
  • MD5
  • SHA1
  • LIKE
  • LOAD_FILE
  • MATCH
  • SOUNDS LIKE

SQLWays Product Page - Migration to MySQL Free Evaluation