CODE EXAMPLE FOR SQL

how to get notinteger value in sql

'//Got it by using a regular expression
//works in mysql for sure'

SELECT * FROM `table`
WHERE column NOT REGEXP '^-?[0-9]+$'