mardi 5 novembre 2019

Best way to write the Query for in Laravel 5 for conditionally adding between on same column

select * from jobs where (status = 'publish' and user_id != 19 and trip_theme_id in (8) and ((budget < 20000 or is_budget = 0) and (budget < 20000 or is_budget = 0) or ( budget between 20000 and 49999 and is_budget = 1))) and jobs.deleted_at is null order by jobs.created_at desc



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire