MySQL Advanced Functions

Showing 5 of 19 records (Sample Data)

Function Description
BIN Returns a binary representation of a number
BINARY Converts a value to a binary string
CASE Goes through conditions and return a value when the first condition is met
CAST Converts a value (of any type) into a specified datatype
COALESCE Returns the first non-null value in a list

Notes

  • Last updated on January 27, 2020