PDO Suggest refine results different than wildcard symbol

I am trying to make a PDO query to be searchable not only by the whole string but also by first letter or last letter anything like this. My question is what approach I have to take to achieve this goal.

My original idea was to use wildcard symbol and something like the following:

SELECT * FROM idname WHERE field LIKE CONCAT('%', :field , '%')

but this option for me is not working since I am getting an error: Warning: Division by zero in

My code ad the moment is the following:

try
{

$paginate = new pagination($page, 'SELECT * FROM idname WHERE field LIKE :field, $options);


}
catch(paginationException $e)
{
    echo $e;
    exit();
}

$paginate->bindValue(':field', $_POST['field'] , PDO::PARAM_STR);
$paginate->execute();

Any suggestions are welcome ?