I know this is not a basic command but can anyone explain to me the use of command called "cast"?

Answer 1

Cast takes a value of any type and returns a value of the specified type. The syntax is:
CAST(expr AS type)
see: http://dev.mysql.com/doc/refman/5.7/en/cast-functions.html for more detail.