Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to get non integer value in sql

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

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