Search
 
SCRIPT & CODE EXAMPLE
 

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]+$' 
Comment

PREVIOUS NEXT
Code Example
Sql :: sql server current date without time 
Sql :: check connections to database postgres 
Sql :: psql uri example 
Sql :: oracle create synonym 
Sql :: grant revoke privileges to mysql username 
Sql :: could not find driver (SQL: PRAGMA foreign_keys = ON;) 
Sql :: get tables in database sql 
Sql :: sql list all databases 
Sql :: how to edit table name in mysql 
Sql :: string to int mysql 
Sql :: UseSqlServer no definition 
Sql :: mysql database stopped xampp mac 
Sql :: sql server check version 
Sql :: postgresql truncate cascade restart identity 
Sql :: flutter sqlite auto incrementing id primary key 
Sql :: Mysql query add column with default string value 
Sql :: how to set an already made tables auto increment in mysql 
Sql :: delete database mysql 
Sql :: mysql last 6 months 
Sql :: how to run mysql in git bash 
Sql :: oracle first and last day of previous month 
Sql :: adding a default constraint to an existing column in sql 
Sql :: generate c# class from sql server table 
Sql :: how to backup mysql database linux 
Sql :: sql how to replace full stop 
Sql :: add mysql to path 
Sql :: oracle user tables 
Sql :: mysql get count of rows 
Sql :: add new column to the table mysql 
Sql :: sql change password wordpress 
ADD CONTENT
Topic
Content
Source link
Name
9+3 =