Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql query to check if column contains alphabets

SELECT * 
FROM table_name
WHERE CAST(PRIME_KEY AS STRING) RLIKE '([0-9]+[a-z]+)'
Comment

PREVIOUS NEXT
Code Example
Sql :: postgresql if else endif 
Sql :: oracle session statistics 
Sql :: psql no such file or directory 
Sql :: Get all index postgres 
Sql :: what is having clause in sql 
Sql :: mysql case when in select 
Sql :: postgres data location 
Sql :: declare value in sql 
Sql :: sql server change column data type 
Sql :: oracle default date format 
Sql :: sql ending with vowels 
Sql :: postgresql change user role grant 
Sql :: sum mysql 
Sql :: SQLITE_BUSY: database is locked 
Sql :: mysql if statement 
Sql :: oracle create tablespace autoextend 
Sql :: mysql count unique in group statement 
Sql :: select odd records sql 
Sql :: sqlite 3 mac 
Sql :: mysql command 
Sql :: express mysql 
Sql :: show tablespace oracle 
Sql :: delete table cassandra 
Sql :: change column name sql 
Sql :: setval in postgres 
Sql :: how to get last inserted id in sql server c# 
Sql :: sqlite modify row 
Sql :: what is cursor in sql server with example 
Sql :: drop procedure if exists sql server 
Sql :: SQL FETCH FIRST Clause 
ADD CONTENT
Topic
Content
Source link
Name
3+5 =