How to convert this sql query to cakephp 3 Query Builder?

Question

SELECT IF(approved = 1,'Yes','No') AS Status
FROM support;

Thomas Rollet · Accepted Answer · 2017-01-12 12:50:10Z

1

$supportTable = TableRegistry::get('Support');
$support = $supportTable->find()->select(["status" => "IF(approved = 1,'Yes','No')"])->toArray();

You can try this one

Thomas Rollet

1,5694 gold badges19 silver badges33 bronze badges

answered Jan 12, 2017 at 12:04

Mahendraprasath D

349 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1