Use cases condition in sql query laravel

This article is tagged with: Use cases condition in sql query laravel and mysql

use cases condition in sql query laravel

->selectRaw("shares.id AS share_id, users.id AS user_id ,
shares.connected_user_id ,
shares.original_language_id, shares.image,
users.first_name, users.last_name, users.email,
locations.city, provinces.name, countries.code,
locations.lat, locations.lng,
shares.created_at,
(CASE WHEN users.id = {$user} THEN 1 ELSE 0 END) AS is_user)")
->orderBy('shares.created_at', 'desc')

This article is tagged with: Use cases condition in sql query laravel and mysql