...
Code Block | ||
---|---|---|
| ||
// Produces SELECT `id`,`id_code` AS `key`,`user_id` FROM `clients`
$this->Record->select(array("id","id_code"=>"key","user_id"))->from("clients");
// Produces SELECT `id`, 'customer' AS `type` FROM `clients`
$this->Record->select(array("id"))->select(array('\'customer\''=> "type"), false)->from("clients"); |
Limit
Code Block | ||
---|---|---|
| ||
// Produces SELECT * FROM `clients` LIMIT 20, 10 $this->Record->select()->from("clients")->limit(10, 20); |
...