select substring('042-55019999',charindex('-','042-55019999')+1,(len('042-55019999')-charindex('-','042-55019999')))
select substring(tupian,charindex('/',tupian)+1,(len(tupian)-charindex('-',tupian))) from product where pid=1
- 2009-05-22 15:52
- 浏览 1295
- 评论(0)