Eirtaza Eirtaza - 1 year ago 106
SQL Question

How to use array with LIKE with whereIn to retrieve eloquent rows in Laravel

I have an array

//dynamically generated. dynamic number of elements
$keywords = ['google', 'youlense'];

For a exactly matching values of
mapping to row in content column, i can do following:

$result = \App\Table::where(function($query){
$query->whereIn('content', $keywords);

and the result would be somewhat

select * from tables where content IN ('google', 'youlense');

but I want to use
operator so the result may be like

select * from tables where content LIKE ('%google%', '%youlense%');

I know that is not allowed in mysql but can some one recommend a simple and clean technique to handle this

Answer Source

You can simply use orWhere method for every keyword and it will equivalent for whereIn. The code will look like:

$result = \App\Table::where(function($query){
    $query->orWhere('content', 'LIKE', '%google%')
          ->orWhere('content', 'LIKE', '%youlense%')
          -> and so on;

$result = \App\Table::where(function($query) use($keywords){
    foreach($keywords as $keyword) {
        $query->orWhere('content', 'LIKE', "%$keywords%")

Note: gotten query can work very slowly.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download