====== 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');