what does $input look like? does it contain a %?

possibly you might want something like $search->execute('%'.$input.'%'); SQL LIKE Operator