Run the below SQL to check if your specified column have any other character other than digit.
select * from database.table_name where column_name regexp '[^0-9]';
Run the below SQL to check if your specified column have any other character other than digit.
select * from database.table_name where column_name regexp '[^0-9]';
Leave a Reply