Syntax:
CAST(expr AS type)

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

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

