Top "Casing" questions

MySQL automatically cast/convert a string to a number?

Does MySQL automatically casting\converting the string to numeric value? How does that conversion works? '1234'=1234 ? '1abc' = 1 ? 'text' = 1 ? …

mysql type-conversion casing