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 :: sql change column types
Sql :: mysql change user password
Sql :: fetch first 5 rows in oracle sql developer
Sql :: wordpress database add admin
Sql :: sql server find columns list in tables
Sql :: join first name and last name sql
Sql :: oracle list columns schema
Sql :: mysql show databases
Sql :: postgresql list extensions
Sql :: search stored procedures
Sql :: oracle string length
Sql :: mysql command line xampp ubuntu
Sql :: mysql add boolean column
Sql :: mysql first day of year
Sql :: mysql select random id from table
Sql :: autoincrement sqlite command
Sql :: wordpress sql find and replace
Sql :: created at and updated at in mysql
Sql :: mysql get last day of month
Sql :: create table if not exist in sqlite
Sql :: select password from user mysql
Sql :: postgresql drop primary key constraint
Sql :: oracle truncate partition
Sql :: mysql import sql file
Sql :: mysql get yesterday
Sql :: count mysql server db tables
Sql :: show table status command in mysql
Sql :: create table mysql query
Sql :: mysql show table column full description
Sql :: for loop postgresql