The CAST() function takes a value of one type and produce a value of another type, similar to CONVERT() . See the ...
dev.mysql.com