CODEWITHSUNDEEP
mysqlcakephp-3.0
Ananthaselvam P
Ananthaselvam P

Reputation: 382

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

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

Upvotes: 0

Views: 245

Answers (1)

Mahendraprasath D
Mahendraprasath D

Reputation: 34

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

You can try this one

Upvotes: 1

Related Questions