php - 如何在 Codeigniter 中生成此 MySQL 代码？

Question

这是我的 MySQL 代码。我是 Codeigniter 的新手。

SELECT
    a.school_code,
    b.Us_News_Ranking,
    b.School_Name,
    COUNT( * ) AS LSN_APPLICATIONS,
    COUNT( a.status ) AS STATUS,
    COUNT( 
        CASE
            WHEN a.status =  'w'
            THEN a.status
        END
    ) AS accp_rate,
    COUNT( 
        CASE
            WHEN a.status =  'Intend_to_apply'
            THEN a.status
        END
    ) AS accp_rate2,
    AVG( CAST( a.Med_LSAT AS DECIMAL( 12, 2 ) ) ) AS MEd_LSAT,
    AVG( CAST( a.Med_GPA AS DECIMAL( 12, 2 ) ) ) AS MEd_GPA
FROM user_application a, lawscools b
WHERE a.school_code = b.school_code
GROUP BY school_code
LIMIT 0 , 30

Answer 1

您可以使用查询功能

$this->db->query('SQL_CODE');

嗯..我想还有另一种方法，但为什么不呢？ :)