SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ILIKE ? or LOWER(name) ILIKE ?)' at line 1 (SQL: select count(*) as aggregate from `users` where (LOWER(email) ILIKE Roman or LOWER(name) ILIKE Roman))

$users = $users->where(function (Builder $query) use ($search, $user) {
   return $query->where( 'email', 'ilike', "%$user%" )
         ->orWhere('name', 'ilike', "%$user%" );
  });


SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ilike ? or `name` ilike ?)' at line 1 (SQL: select count(*) as aggregate from `users` where (`email` ilike %Roman% or `name` ilike %Roman%))

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'LOWER(email)' in 'where clause' (SQL: select count(*) as aggregate from `users` where (`LOWER(email)` LIKE %roman% or `LOWER(name)` LIKE %roman%))
Previous exceptions