如何将mysql转换为laravel查询生成器 [英] How to convert mysql to laravel query builder

问题描述

大家好，我在mysql中有这个原始查询，我需要翻译成laravel 5.4查询生成器

Hi all i have this raw query in mysql i need to translate to laravel 5.4 query builder

select * from pages where (phase_id, type) in (select max(phase_id),type from pages where phase_id<=2 and actived=1 group by type) and actived=1

我不知道如何在具有2列的clausule的查询构建器中进行转换

i don't know how to convert in query builder where clausule with 2 colum

有什么想法吗?

全力以赴

推荐答案

$results = DB::select(
    select * from pages where (phase_id, type) 
    in (
        select max(phase_id), type 
        from pages 
        where phase_id <= 2 
        and actived = 1 
        group by type
    ) 
    and actived = 1
);

这篇关于如何将mysql转换为laravel查询生成器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！