xxxxxxxxxx
$client->select("SELECT * FROM USERS WHERE ilike(a.full_name, :full_name)",[
'full_name' => '%'.$data->full_name.'%'
]);
xxxxxxxxxx
┌─id─┬─name─────┬─days─┐
│ 1 │ January │ 31 │
│ 2 │ February │ 29 │
│ 3 │ March │ 31 │
│ 4 │ April │ 30 │
└────┴──────────┴─────┘
SELECT * FROM Months WHERE ilike(name, '%j%');
┌─id─┬─name────┬─days─┐
│ 1 │ January │ 31 │
└────┴─────────┴─────┘