例
select substr(substr(c630000036,instr(c630000036,'000000000004775'),length(c630000036)),0,length(substr(c630000036,instr(c630000036,'000000000004775'),length(c630000036)))-1) aa from t157
where c630000036 =(select c630000036 from t157 where instr(c630000036,'000000000004775')>0)
instr(c630000036,'000000000004775')
用instr 函数c630000036字段中查找'000000000004775',如果c630000036里面的值存在则返回 下标值
substr(c630000036,instr(c630000036,'000000000004775'),length(c630000036))
substr 截取字符串,在c630000036值里面截取,从instr(c630000036,'000000000004775')开始,length(c630000036) 结束位置
这样就能获取到想要的是什么勒