select top 5 ClassID,ChannelID,Depth,ClassName,OrderID,mid(ClassBasicInfo,1,instr(ClassBasicInfo,"$")-1) as 栏目图片 from [KS_Class] where ChannelID=4 and Depth=1
select 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 id in ( SELECT id FROM KS_CLASS where TN ='$Param(0)}') order by id desc