duanji1610 2017-01-31 06:52
浏览 52
已采纳

如何在学说ORM中搜索一个单词?

I would like to know if this is possible in doctrine ORM symfony. I have a list of Products. Each product has a Title. let say their titles are:

1. Great Mango
2. Show Mango
3. King Mango

I use this doctrine to find the title

$repository->findByTitle("Mango");

but I display nothing. If I complete the title to search it like "King Mango". It display but not the list with the MANGO word.

I used this link for reference. but if you have more documentation about this. I'm happy to learn from it.

  • 写回答

2条回答 默认 最新

  • dongre6270 2017-01-31 07:10
    关注

    The magic methods only work with exact search. To use a LIKE statement, you'll have to create your own repository, as described here: http://symfony.com/doc/current/doctrine/repository.html

    Once you have your own repository class, create a method that uses LIKE in the query:

    public function findByTitlePart($title)
    {
        return $this->getEntityManager()
            ->createQuery(
                'SELECT p FROM AppBundle:Product p WHERE p.title LIKE :title'
            )
            ->setParameter('title', '%' . $title . '%')
            ->getResult();
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 数据结构—复杂度分析
  • ¥15 如何使用单链表编写学生信息管理系统?
  • ¥15 完成课题以及ppt 在21号之前完成
  • ¥15 懂的来,你应该知道我在说什么,我需要你的帮助
  • ¥15 关于#java#的问题,请各位专家解答!
  • ¥15 maccms影视模板 制作影视网站失败 求
  • ¥15 stm32按键设置闹钟数进退位不正常
  • ¥15 自己写的测试驱动程序无法启动
  • ¥15 三电平逆变器中点电位平衡问题
  • ¥20 这怎么写啊 java课设