Search
 
SCRIPT & CODE EXAMPLE
 

SQL

replace all numbers in mysql

Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(column_name,'9',''),'8',''),'7',''),'6',''),'5',''),'4',''),'3',''),'2',''),'1',''),'0','')
Comment
PREVIOUS NEXT
Code Example
Sql :: convert rows to columns in sql server 
Sql :: postgresql update between 2 tables 
Sql :: sql check if date is between 2 dates 
Sql :: drop foreign key mysql 
Sql :: sql where keyword contains 
Sql :: sql group by year 
Sql :: postgresql today - 1 year 
Sql :: pl sql ptint 
Sql :: date formats in sql server 
Sql :: get only structure database mysql 
Sql :: sqlite3 show columns name 
Sql :: find duplicate keys in mysql 
Sql :: how to get the number of columns in a table in sql 
Sql :: random name function in mysql for nvarchar 
Sql :: locate sql server 
Sql :: postgresql extract hour and minutes from timestamp 
Sql :: create table in mysql 
Sql :: SQL Remove Index From Tables 
Sql :: running percentage of total postgres 
Sql :: SQL Auto Increment Primary Key - SQL Server 
Sql :: postgres check for foreign key 
Sql :: oracle desc table primary key 
Sql :: sqlite truncate tables command 
Sql :: oracle nextval 
Sql :: postgresql add column 
Sql :: sql get the name of user pc 
Sql :: sql current timestamp table 
Sql :: create temporal table in sql 
Sql :: kill a pid redshift 
Sql :: temp table vs variable table in sql server 
ADD CONTENT
Topic
Content
Source link
Name
7+5 =