MySQL Type Conversion :

    Type conversion takes place when operators are used with different types of operands in an expression. Some conversions are done implicitly and some need explicit conversions.

    In MySQL the numbers are converted to strings and sometimes strings to numbers depending upon the condition.

    Let us consider an example for converting a string to an integer.

mysql> Select 1+'11';
 --> 12

mysql> select concat(1, ' HIOX');
 --> '1 HIOX'

mysql> select 12, cast(12 as char);
 --> 12, '12'
mysql> select 12, concat(12);
 --> 12, '12'