Often you need to do some MySQL query operation conditionally. You may need get any column value conditionally. How you will do that?
Here is the example. You can either IF ELSE or CASE WHEN for conditional queries.
If and Else:
Products::SELECT(DB::raw('IF(MIN(products.start_at) IS NULL, products.started_at, MIN(products.start_at)) as start_at'))->get();
Products::SELECT(DB::raw('CASE WHEN COUNT(products.user_id) != 0 THEN COUNT(products.user_id) ELSE 1 END as user_id'))->get();