Laravel查询生成器搜索(匹配) [英] Laravel Query Builder Search (match against)
本文介绍了Laravel查询生成器搜索(匹配)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试用Laravel编写此查询
I'm trying to write this query in Laravel
select *, MATCH(hobbies)AGAINST('soccer') from users where MATCH(hobbies)AGAINST('soccer' IN BOOLEAN MODE) LIMIT 10 OFFSET 0;
我看过查询生成器的文档,但是在全文搜索中什么都没找到.
I have looked in the documentation on query builder but didn't find anything on full-text search.
请帮助.
预先感谢您:)
推荐答案
感谢Samsquanch,他为我指出了正确的方向. 这是我的完成方式.
Thanks to Samsquanch he pointed me in the right direction. Here is how I got it done.
$my_query = "select *, MATCH (name) AGAINST (?) from users
where MATCH (hobbies) AGAINST (? IN BOOLEAN MODE) limit 10 OFFSET ?"
$hobbies = DB::select($my_query, array($search_term, $search_term, (($page-1)*10)));
这篇关于Laravel查询生成器搜索(匹配)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文