栏目介绍语句：

select top 100 id,foldername,mid(classbasicinfo,instr(classbasicinfo,"||||")+4) as s,mid(s,1,instr(s,"||||")-1) as 栏目介绍 from ks_class where tj=1 order by folderorder

取栏目图片:

select top 100 id,foldername,mid(classbasicinfo,1,instr(classbasicinfo,"||||")-1) as 栏目图片 from ks_class where tj=1 order by folderorder

综合写就成了这样:

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数据库中测试通过!

为免栏目介绍里包含|,改用了||||．一定要注意，在你的栏目介绍里不能包含||||