How to make my SQL query search several words in the sentence even if they do not follow each other

Question

I have a SQL query for my search form.

$term = $request->get('term');

$queries = Article::where('title', 'LIKE', '%' . $term . '%')->published()->get();

My research is working. If I have an article called "my great article is awesome" and that I write in my search form "greate article" it works.

But if I write "article awesome", the words do not follow each other, and it does not work.

How do I get my query to work just with keywords?

Thank you

Answer 1

You can do something like follows:

$term = $request->get('term');
$keywords = explode(" ", $term);

$article = Article::query();
foreach($keywords as $word){
    $article->orWhere('title', 'LIKE', '%'.$word.'%');
}

$articles = $article->published()->get();

If you want only results that contain all the words in the query just replace the orWhere with where.

If you want to filter out certain words you could add something like:

$filtered = ["a", "an", "the"];
$filteredKeywords = array_diff($keywords, $filtered);

Alternatively you can pass a closure if you want to be more dynamic:

$filteredKeywords = array_filter($keywords, function($word) {
    return strlen($word) > 2;
});