ALTER TABLE ip MODIFY isp INT UNSIGNED NOT NULL;

ERROR 1366 (HY000): Incorrect integer value: '' for column 'isp' at row 2

update ip
set isp = '0' where trim(coalesce(isp, '')) = '';

update ip
set isp = '0' where trim(isp) = '';