->select('users.id AS user_id', 'users.name',
DB::raw('(CASE WHEN users.status = 0
THEN "active" WHEN users.status = 1
THEN "not active"
ELSE "pending" END) AS
status_user'))
->orderBy('shares.created_at', 'desc')
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter