Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql where column not integer

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

SELECT * FROM `table`
WHERE column NOT REGEXP '^-?[0-9]+$' 
 
PREVIOUS NEXT
Tagged: #mysql #column #integer
ADD COMMENT
Topic
Name
4+5 =