Sql

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

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

PREVIOUS	NEXT

Code Example
Sql :: doublon sql
Sql :: uninstall postgresql mac
Sql :: kill mysql processlist in whose time more than 200
Sql :: oracle find unusable indexes
Sql :: oracle get current schema
Sql :: SELECT list is not in GROUP BY clause
Sql :: mysql stop password policy
Sql :: display all databases
Sql :: too many connections mysql
Sql :: mysql grant all privileges to a user
Sql :: Mysql Case sum
Sql :: mysql change database charset and collation
Sql :: show list of users in mysql
Sql :: sql first day of current year
Sql :: mysql get longest string in column
Sql :: how to start mysql
Sql :: rename table sql
Sql :: mysql command line connect
Sql :: mysql last day of next month
Sql :: sql between date range
Sql :: postgres alter table add primary key
Sql :: postgres select from last 3 months
Sql :: postgresql if 0 then 1
Sql :: grant permission in postgres
Sql :: oracle drop chain step
Sql :: extract month from date sql two digits
Sql :: current setting postgres timezone
Sql :: mysql add column default value
Sql :: mysql random number between 1 and 100
Sql :: mysql date format unix timestamp