我该如何重写这个SQL到codeIgniter的活动记录? [英] How can I rewrite this SQL into CodeIgniter's Active Records?
本文介绍了我该如何重写这个SQL到codeIgniter的活动记录?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SELECT *,SUM(tbl.relevance)从相关性
(
(
SELECT q_id,
MATCH(a_content)反对(бутон')AS相关性
从答案
哪里
MATCH(a_content)反对(бутон)
)
联盟
(
SELECT q_id,
(MATCH(q_content)反对(бутон'))* 1.5 AS的相关性
从问题
哪里
MATCH(q_content)反对(бутон)
)
)AS TBL
JOIN问题ON questions.q_id = tbl.q_id
GROUP BY tbl.q_id
排序方式按何种降序
解决方案
codeigniter 目前没有子查询支持,它的有效记录类。
你只需要使用这样的:
$这个 - > DB->查询($ your_query,FALSE);
记住要传递的第二个参数,使 codeigniter 不试图逃跑查询。
SELECT *, SUM(tbl.relevance) AS relevance FROM
(
(
SELECT q_id,
MATCH(a_content) AGAINST ('бутон') AS relevance
FROM answers
WHERE
MATCH(a_content) AGAINST ('бутон')
)
UNION
(
SELECT q_id,
(MATCH(q_content) AGAINST ('бутон')) * 1.5 AS relevance
FROM questions
WHERE
MATCH(q_content) AGAINST ('бутон')
)
) AS tbl
JOIN questions ON questions.q_id = tbl.q_id
GROUP BY tbl.q_id
ORDER BY relevance DESC
解决方案
Codeigniter currently does not have support for subqueries in its Active Records class.
You'll simply have to use this:
$this->db->query($your_query, FALSE);
Remember to pass that second argument, so that Codeigniter doesn't try to escape your query.
这篇关于我该如何重写这个SQL到codeIgniter的活动记录?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文