Syntax:
CAST(expr AS type)

The CAST() function takes an expression of any type and produces a
result value of the specified type, similar to CONVERT(). For more
information, see the description of CONVERT().

CAST() is standard SQL syntax.

URL: http://dev.mysql.com/doc/refman/5.5/en/cast-functions.html

