Support the ongoing development of Laravel.io →
mygithubuser
posted 10 years ago
Database Eloquent
Last updated 2 years ago.
0
screenager
replied 9 years ago

I think "orWhereRaw" is what you are looking for:

$projects
->whereRAW("MATCH(name,description) AGAINST(? IN BOOLEAN MODE)",array($search))
->orWhereRAW('id IN (SELECT project_id FROM roles JOIN users ON user.id = roles.user_id WHERE MATCH(username, first_name, last_name) AGAINST(? IN BOOLEAN MODE))', array($search));
->orWhereRaw('...')
Last updated 9 years ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

mygithubuser mygithubuser Joined 19 Feb 2014

Moderators

We'd like to thank these amazing companies for supporting us

Eventy
Fathom
Forge
Envoyer
Beyond Code
Skynet Technologies
BairesDev
Remotely Works
Dotcom-monitor
N-iX

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Forum Articles Pastebin

Socials

X Twitter GitHub

The community

Laravel Laravel Laravel News Laravel News
Laracasts Laracasts Laravel Podcast Laravel Podcast
© 2024 Laravel.io - All rights reserved.
Terms of service Privacy policy Advertise