select '123' * 2;

To make the multiplication with 2 MySQL automatically converts the string 123 into a number.

Return value:

246

The conversion to a number starts from left to right. If the conversion is not possible the result is 0

select '123ABC' * 2

Return value:

246

select 'ABC123' * 2

Return value:

0