如何设置limit $ this-> User-> findByFirstName（'Nadim'）;

Question

How to set limit to this query

$this->User->findByFirstName('Nadim',array('User.id','User.first_name','User.last_name'));

it sql is

SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name` FROM `users` AS `User` WHERE `User`.`first_name` = 'Nadim' limit 1

I want to remove limit 1

Answer 1

the findBy() functions return results like find('first'), you cannot set limit to it, you need to use findAllBy() instead.