[Symfony 4][Doctrine 2]查询数组字段

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 */
class MyEntity
{
    // ...

    /**
     * @ORM\Column(type="array")
     */
    private $myArrayField;

    // ...
}

use Doctrine\ORM\EntityManagerInterface;

// ...

class MyController
{
    private $entityManager;

    public function __construct(EntityManagerInterface $entityManager)
    {
        $this->entityManager = $entityManager;
    }

    public function myAction()
    {
        $qb = $this->entityManager->createQueryBuilder();

        $qb->select('e')
            ->from(MyEntity::class, 'e')
            ->where($qb->expr()->contains('e.myArrayField', ':value'))
            ->setParameter('value', 'some value');

        $query = $qb->getQuery();
        $result = $query->getResult();

        // ...
    }
}