Nov 10, 2018

How to convert a string with scientific notation to an int in MySQL

For example 1.4626028E7 to 14626028

CAST('1.4626028E7' as DECIMAL)