注册
找回密码
账号 记住
5327
11
10439
0
18
sql数据库的话,应该是charindex
select top 100 id,foldername,mid(classbasicinfo,instr(classbasicinfo,"||||")+4) as s,mid(s,1,instr(s,"||||")-1) as 栏目介绍 ,mid(classbasicinfo,1,instr(classbasicinfo,"||||")-1) as 栏目图片 from ks_class where tj=1 order by folderorder
这一句在access数据库里测试通过