title: using case in the query of cakephp
body: <p>How can I write the following sql query in the cakephp format</p>
  
  <pre><code>SELECT 
  `ActivityLog`.`id`, 
  CASE User.user_type
  WHEN 'admin' THEN concat_ws(' ',Admin.first_name,Admin.last_name)
  END,
  FROM `project`.`activity_logs` AS `ActivityLog` 
  left join users as User on ActivityLog.user_id = User.id 
  left join admins as Admin on User.id = Admin.user_id
  WHERE 1 = 1 ORDER BY `ActivityLog`.`datetime` desc
  </code></pre>
  
  <p>Everything is fine except the <code>case</code> statement, pls help me..</p>