====== find ======
~~NOTOC~~
== Syntax ==
array|bool find(
string $where
optional string $bindarr=false,
optional string $pkeysArr=false,
optional array $extra=array()
)
===== Description =====
This function locates records the match the //**where**// string in any portion of the database record and returns an array of results.
If no results are returned the method returns false
It is part of both [[v5:activerecord:activerecord_index#active_records_extended|Extended Active Record]] and [[v5:activerecord:activerecord_index#active_records|Active Record]]
--------------------------------------
===== Parameters =====
==== $where ====
An SQL string (not including WHERE to match a subset of records
==== $bindarr ====
An optional array of bind variables if required by the where statement
==== $pkeysArr ====
==== $extra ====
$extra provides an optional set of parameters
|Parameter|Description|
|limit| Select Record Limit|
|offset| Select Record Offset|
===== Usage =====
This example finds all entries in the persons table whose birth date is less than 2019-01-01
$person = new Person;
$person->find('birth_date<2019-01-01');