Like
Like
The steps to made a like in a where condition using ivory just involves a few properties more.
Example
//import the ivory class
require_once('Operations.php');
//the instance of the ivory
$ivoryOrm = new Operations();
$arrSelect[] = "name";
$arrSelect[] = "email";
$tables[] = "users";
$arrWhere[] = [
"propName" => "name",
"fieldValue" => "",
"like" => true,
"pattern" => "%Jon%",
];
//the method select creates the query : SELECT name,email FROM users WHERE name LIKE '%Jon%';
$select = $ivoryOrm->select($arrSelect, $tables);
$selectWhere = $ivoryOrm->where($select, $arrWhere);
//the method runQuery is responsible to literally run your query into the database;
$result = $ivoryOrm->runQuery($selectWhere);
More About Patterns in SQL can be found here: https://www.w3schools.com/sql/sql_like.asp