摘要:
update newpllccn_jiangjingfenlei set classid=left(SUBSTRING(url,PATINDEX('%[0-9]%',url),LEN(url)),patindex('%[^0-9]%',SUBSTRING(url,PATINDEX('%[0-9]%' 阅读全文
posted @ 2020-11-05 10:02
明净
阅读(230)
评论(0)
推荐(0)
|
摘要:
update newpllccn_jiangjingfenlei set classid=left(SUBSTRING(url,PATINDEX('%[0-9]%',url),LEN(url)),patindex('%[^0-9]%',SUBSTRING(url,PATINDEX('%[0-9]%' 阅读全文
posted @ 2020-11-05 10:02
明净
阅读(230)
评论(0)
推荐(0)
|