How to convert mysql to laravel query builder [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 8 years ago.

Improve this question

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

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

any ideas?

Thx all

EddyTheDove · Accepted Answer · 2017-03-03 09:35:51Z

1

$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
);

answered Mar 3, 2017 at 9:35

EddyTheDove

13.2k2 gold badges40 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

DaveIt Over a year ago

Thx @EddyTheDove ;) exists another way using ->whare() or whareIn() method of query builder?

EddyTheDove Over a year ago

if you have an array of IDs, yes you can use whereIn. But it doesnt take SQL like that. You must pass it an array.

Collectives™ on Stack Overflow

How to convert mysql to laravel query builder [closed]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related