这句mysql语句如何排先后呀

这句mysql语句怎么排先后呀?
SELECT * FROM text where (`title` like '%我们%' and `title` like '%他们%') or (`title` like '%我们%' or `title` like '%他们%') limit 6

有办法先把前一个条件的(`title` like '%我们%' and `title` like '%他们%')列出来在列出后面条件的吗？

------解决方案--------------------
试试这样？

SQL code

SELECT *, ((`title` like '%我们%' and `title` like '%他们%') * 0.8 + (`title` like '%我们%' or `title` like '%他们%') * 0.2) AS relevanceFROM textWHERE (`title` like '%我们%' and `title` like '%他们%') or (`title` like '%我们%' or `title` like '%他们%') ORDER BY relevance DESClimit 6
------解决方案--------------------

SQL code

SELECT * FROM (         SELECT * FROM `text` where `title` like '%我们%' and `title` like '%他们%') ttWHERE  `title` like '%我们%' or `title` like '%他们%' limit 6;
------解决方案--------------------

SQL code

SELECT *, 1 as xh FROM text where (`title` like '%我们%' and `title` like '%他们%')unionSELECT *, 2 as xh FROM text where (`title` like '%我们%' or `title` like '%他们%')order by xhlimit 6

声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系[e-mail]核实处理。
相关文章
相关视频

• 谈网页编程PHP语言的发展_PHP教程
• 模拟OICQ的实现思路和核心程序三转--建议加入精...
• php新手入门经验谈_PHP教程
• 关于中英数字混的字串符分割问题_PHP教程
• 这句mysql语句如何排先后呀

• MySQL LIKE 子句
• SQLite Like 子句
• <title>
• like语法
• id,class,title,style标签四大通用属性