Lab Sql

How to convert this raw query to Laravel eloquent way: select c.name as country from country c, add… Read more Convert Raw Query To Laravel Eloquent

I have a table where I store different blocks of texts for my website. I am currently selecting the… Read more How To Select Items From A Table Based On One Value If Another Value Does Not Exists? (eloquent/sql)

I thought this would be fairly simple but it's not playing ball currently. I have 2 tables for … Read more Laravel Eloquent - Where Relationship Field Does Not Equal

I am developing a web app that interfaces with an ERP production database and the data is being ret… Read more Making A Laravel Model Use Complex Query As Table

I have a user model which has a child relationship called teacher. How can I add a field from the r… Read more Laravel 5 Eloquent - Add Child Field To Parent Model

In my Laravel project, in the database table ads, I have the following structure : id | col1 | col… Read more Laravel - Randomly Select N Number Of Rows Containing Same Value In Certain Column After Applying 'order By'

I have been this SQL working fine, but trying to convert it to Eloquent format, it keeps returning … Read more Convert Sql To Eloquent To Join Multiple Table And Count

For an online competition with the goal of photographing certain objects I've got users uploadi… Read more Eloquent Nested Where Statement