Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function search($keyword)
- {
- $query = 'SELECT v
- FROM VelvelZDFBundle:Video v
- WHERE v.title LIKE :keyword
- OR v.subtitle LIKE :keyword
- OR v.description LIKE :keyword
- ORDER BY
- CASE WHEN v.title LIKE :keyword
- AND v.subtitle LIKE :keyword
- AND v.description LIKE :keyword
- THEN 0
- WHEN v.title LIKE :keyword
- AND v.subtitle LIKE :keyword
- THEN 1
- WHEN v.title LIKE :keyword
- AND v.description LIKE :keyword
- THEN 2
- WHEN v.subtitle LIKE :keyword
- AND v.description LIKE :keyword
- THEN 3
- WHEN v.title LIKE :keyword
- THEN 4
- WHEN v.subtitle LIKE :keyword
- THEN 5
- WHEN v.description LIKE :keyword
- THEN 6
- END ASC , id DESC';
- return $this->em->createQuery($query)->setParameter('keyword', '%' . $keyword . '%')->getResult();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement