Level 75
Do partial search, like %op%. Etc.
Nov 8, 2021
8
Level 1
Advanced Search Query with Eloquent
I have a mobile phone specs website. I'm using the following query it returns results correctly:
$q = 'oppo reno';
Phone::where('name', 'like', sprintf('%%%s%%', $q))->get();
However, if we change the position of words of the search query to the following, it won't return any results.
$q = 'reno oppo';
Phone::where('name', 'like', sprintf('%%%s%%', $q))->get();
Any help is appreciated, thanks!
Level 1
@jlrdw Sorry, but it's not something that would work for this case
Level 35
Your current query is only searching for the text provided in the search, and any characters around it.
For example:
oppo reno or blah oppo reno blah
will match.
reno oppo will not match because oppo reno is not found within it.
What you need is a feature called "typo tolerance" and is one of the main reasons for using Laravel Scout: https://laravel.com/docs/8.x/scout.
Laracasts: https://laracasts.com/series/learn-laravel-scout
Algolia and MeiliSearch drivers are offered, the latter being free and open source.
Level 1
@drehimself I'll try it out, thanks!
Level 73
I take it you want to search for each of the words oppo and reno If so you can explode the search string and then loop over the array dynamically building the query and then execute it.
Level 1
@Tray2 I already tried that. That would return unnecessary results. For example, if the query is "oppo reno" or "reno oppo" it would return all Oppo phones but the user only wanted to see reno series phones. Thanks for the suggestion.
Level 122
have a look at https://spatie.be/docs/laravel-site-search/v1/introduction
Level 1
@Snapey I'll try it out thanks!
Please or to participate in this conversation.