products
----------------
ID ProductName Model Description我现在进行模糊查询,条件是 productname like '%_keywords%' or Model like '%_keywords%' or
Description like '%_keywords%'但我想按 ProuductName 里找到的排前面, Model 找到的排中间, description 找到的排后面 这如何做呢?
----------------
ID ProductName Model Description我现在进行模糊查询,条件是 productname like '%_keywords%' or Model like '%_keywords%' or
Description like '%_keywords%'但我想按 ProuductName 里找到的排前面, Model 找到的排中间, description 找到的排后面 这如何做呢?
解决方案 »
- 请教:奇异的微软企业库4.1缓存功能
- 怎么使用JS脚本的问题
- windows 2008里 iis7里奇怪的问题
- ASP.NET中数据网格查询出来0条记录怎么解决啊!
- 如何搜索指定字符串
- 面试遇到问题:FROM 子句语法错误。(急,在线等)
- 如何令鼠标移动到datagrid的某一行改变该行的底色?
- 请问怎么让服务器每天定时重启IIS服务?
- kceditor图文混排的内容存到数据库用什么字段?
- VB6.0做的ActiveEXE组件在ASP和HTML中调用没问题,但怎么样在ASP.NET的客户端中调用?
- 求Lion.Web.UpLoadModule或AspnetUpload .NET组件
- 小弟要换工作了,在此求一份个人简历样式啊,谢谢大家了啊。
select * from # where Model like '%_keywords%' union
select * from # where Description like '%_keywords%'
select *,id = 1 from *** where productname like '%_keywords%'
select *,id = 2 from *** where Model like '%_keywords%'
select *,id = 3 from *** where Description like '%_keywords%'
然后联合 就可以
很麻烦。。
我现在是把所有读出来的记录放到 dr 里,select * From Products,Members Where Products.MID=Members.MID and (Products.ProductName like '%" + _keywords + "%' or Products.Model like '%" + _keywords + "%' or Products.Description like '%" + _keywords + "%')我是多表查询的,楼上的大哥,帮帮忙,应该如何写
(
(select *,idsort=1 From Products,Members Where Products.MID=Members.MID and Products.ProductName like '%" + _keywords + "%' )union
(select *,idsort=2 From Products,Members Where Products.MID=Members.MID and Products.Model like '%" + _keywords + "%')union
(select *,idsort=3 From Products,Members Where Products.MID=Members.MID and Products.Description like '%" + _keywords + "%')
) as k
order by k.idsort这样应该就ok了吧,忘记idsort=3应该是as 还是=号了,可以试下
select * From Products,Members Where Products.MID=Members.MID and Products.ProductName like '%" + _keywords + "%' union
select * From Products,Members Where Products.MID=Members.MID and
Products.Model like '%" + _keywords + "%'
union select * From Products,Members Where Products.MID=Members.MID and Products.Description like '%" + _keywords + "%'
select * from # where Model like '%_keywords%' union
select * from # where Description like '%_keywords%'
=========================================================
可以生成3个DataSet,DataSet有个Merge()方法合并3个DataSet。
不确定你那样是否按照lz说的方法排序了
我也没写过,现在只能凭感觉来给个答案了lz有了结果告诉我们下,看看zhaozhao110这样能排序吗
顺便我也学习下
select * from # where Model like '%_keywords%' union
select * from # where Description like '%_keywords%'
(
(select *,idsort=1 From Products,Members Where Products.MID=Members.MID and Products.ProductName like '%" + _keywords + "%' )union
(select *,idsort=2 From Products,Members Where Products.MID=Members.MID and Products.Model like '%" + _keywords + "%')union
(select *,idsort=3 From Products,Members Where Products.MID=Members.MID and Products.Description like '%" + _keywords + "%')
) as k
order by k.idsort方法不是很好,可能会有重复记录
Description like '%_keywords%'
order by productname,Model,Description
不知道这样行不行
zhaozhao110(我死了,在烈火中我又站起来了,你猜是涅盘,还是尸变) ( ) 信誉:100 Blog 加为好友 2007-07-02 10:21:17 得分: 0
select * from # where productname like '%_keywords%' union
select * from # where Model like '%_keywords%' union
select * from # where Description like '%_keywords%'
好像很强啊.这个是正确的.lz没有试试吗