Category: sql

Symfony Doctrine: Search in simple_array

I got values stored in my database column field as value1,value2,value3,value4, so a simple_array column. So i’m using Doctrine to make a search using this: $searchQuery = $this->getDoctrine() ->getRepository(‘AppBundle:Ads’) ->createQueryBuilder(‘p’) ->andWhere(“p.vals <= :value2”) ->setParameter(‘value2’, $request->query->get(‘value2’)); ->orderBy(“p.creationtime”, ‘DESC’); So expecting value2…