Hi Jeffery, How can we search multiple indices at the same time and return any records that match those queries? For example, how can I achieve this:

if($request->has('q')) {
            $jobPosts = DB::table('job_posts')
            ->join('employer_profiles', 'employer_profiles.id', '=', 'job_posts.employer_profile_id')
                ->where('job_title', 'like', '%'.$request->get('q').'%')
                ->orWhere('company_name', 'like', '%'.$request->get('q').'%')
                ->orWhere('city', 'like', '%'.$request->get('q').'%')->get();

            return $jobPosts->count() ? $jobPosts : $error;
        }

I'm joining 2 tables and then looking for 3 columns job_title, company_name and city and I want Full Text Search. So if I search "Graphic Designer, Toronto", it will return all records where title column matches "Graphic Designer" AND all records where city column matches "Toronto". How can I do this using the ::search param on a query?

Something similar to this:

        if($request->has('q')) {
            $jobPosts = JobPost::search($request->q)->get();
            return $jobPosts;
        } else {
            return $jobPosts = [];
        }

Except this is just searching through the job_posts indice alone and not both job_posts and employer_profiles indices. Any idea?

Advanced Search With Laravel Scout: Part 2