mysql字段中数字字符截取(100)

R

rixwy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-17

• #1

mysql 数据库有一字段每一列中都有一串数字代码(长度不固定，位置不固定),如何批量更新将其删除掉？格式如： adfaf 239203 adfasf adfasf afdasf lklkjl liowls iwod 3902 asdfa ls oidsa dsi sdfoie 29023 asdflafs

 

R

ranyang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-17

• #2

想得到的结果是什么？格式如： adfaf 239203 adfasf adfasf afdasf lklkjl liowls iwod 3902 asdfa ls oidsa dsi sdfoie 29023 asdflafs=格式如： adfaf adfasf adfasf afdasf lklkjl liowls iwod asdfa ls oidsa dsi sdfoie asdflafs？？？？是么？

 

R

rixwy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-17

• #3

ranyang,正是想得么这个结果,麻烦帮帮忙

 

R

ranyang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-09-18

• #4

我没有mysql的环境～select 你的字段,REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(你的字段,'0',''),'1',''),'2',''),'3',''),'4',''),'5',''),'6',''),'7',''),'8',''),'9','') filter_num from 你的表;效率不太高～