find

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

An SQL string (not including WHERE to match a subset of records

An optional array of bind variables if required by the where statement

$extra provides an optional set of parameters

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