SQL

mysql select column where has non int values

/*find rows with non int value*/
select * from my_table where abs(user_id) =0;

mysql select non integer values

select * from mytable where mycolumn NOT REGEXP '^-?[0-9]+$';