Doctrine 2 Query with LIKE

sql symfony doctrine-orm
AlOpal19 picture AlOpal19 · Oct 3, 2012 · Viewed 66k times · Source

I have this code for query: 

$repository = $em->getRepository('AcmeCrawlerBundle:Trainings');
       $query = $repository->createQueryBuilder('p')
               ->where('p.title LIKE :word')
               ->orWhere('p.discription LIKE :word')
               ->setParameter('word', $word)
               ->getQuery();
$trainings = $query->getResult();

The problem is: even if matches exist, they not found by this query. I used this code to see full sql: 

print_r(array(
        'sql'        => $query->getSQL(),
        'parameters' => $query->getParameters(),
        ));

And what I've got:

FROM Trainings t0_ WHERE t0_.title LIKE ? OR t0_.discription LIKE ? [parameters] => Array ( [word] => Spoken )

(last part of query) Tell me please what to change?

Answer

Elnur Abdurrakhimov picture Elnur Abdurrakhimov · Oct 3, 2012

You forgot the % signs around the word:

->setParameter('word', '%'.$word.'%')

Related questions

Doctrine query builder using inner join with conditions

I'd like to construct the following SQL using Doctrine's query builder: select c.* from customer c join phone p on p.customer_id = c.id and p.phone = :phone where c.username = :username First I tried $qb->select('c') …

Read More
Left join ON condition AND other condition syntax in Doctrine

I'm using Doctrine's querybuilder in Symfony2 to create a query to fetch entities. My current code looks like this: $repository = $this->getDoctrine()->getRepository('AaaBundle:Application'); $queryBuilder = $repository->createQueryBuilder('a'); $queryBuilder ->addSelect('u') ->…

Read More
Limit amount of records retrieved when using Doctrine DQL in Symfony2

I have the following query: $latestcontent = $em->createQuery(' SELECT c.title, c.content, c.lastedit, a.firstname, a.surname FROM ShoutMainBundle:Content c, ShoutMainBundle:Admin a WHERE c.author = a.id ORDER BY c.lastedit ASC' ); What I …

Read More