I need to create a repository in order to find the specified records (names) in the table.

```
class CategoryRepository extends \Doctrine\ORM\EntityRepository
{
    public function getAllByName($name)
    {
        return  $this->getEntityManager()->createQuery('SELECT * FROM AppBundle\Entity\Category WHERE name LIKE "$name"');
    }
}

```

I did so, but, unfortunately, it does not work. Tell me, please, how can I do this?
MySQL Query need be like this:

```
SELECT * FROM category WHERE name LIKE 'Your_Name'

```