Array to string conversion in Laravel using 'LIKE' query

Question

sorry for a newbie question. I run into a problem. I want to search the database for values which an in array. But I have an error:

Array to string conversion

And kinda get why but, I don't know how to make it right. Can you help me please? This is my code:

public function chassis($chassis){
    return $this->builder->whereIn('model_type_en', 'LIKE', (array)"%$chassis%");
}

P.S please don't laugh at me :)

Like and where in are completely separate things. Builder will probably have method called like with two parameters fieldname and string. Use that without casting to array (array). — Maciej Paprocki, Aug 17 '17 at 12:45
hard, I need to make a solution. People in application want to input many chassis numbers at one time and result should display all of them or at least similar to them — Dmitry Malys, Aug 17 '17 at 12:47
The problem is mysql doesn't support in with array, instead you need to create multiple like statements joined by OR. However, please be aware, big amount of likes like that will make really inefficient query — Maciej Paprocki, Aug 17 '17 at 12:53
@MaciejPaprocki yaa I kind of thinking to give up on LIKE, just use whereIN array — Dmitry Malys, Aug 17 '17 at 12:58

ch271828n · Accepted Answer · 2017-08-17T12:35:32.210

3

$collection = DB::table('your_table')->select('*');
foreach($chassis as $key=>$val) {
    if($key == 0) {
        $collection->where('model_type_en', 'like', "%$val%"));
    }
    $collection->orWhere('model_type_en', 'like', "%$val%"));
}
$name = $collection->get();

This may work. You can also look at the ref: laravel querybuilder how to use like in wherein function

(original wrong ans:)

If chassis is a string, you can do this:

$this->builder->where('model_type_en', 'LIKE', "%$chassis%");

You can read the docs: https://laravel.com/docs/5.4/queries

edited Aug 17 '17 at 12:35

answered Aug 17 '17 at 12:27

ch271828n

15,854
5
53
88

I fear he might still get the array to string conversion – DarkMukke Aug 17 '17 at 12:30
chassis is an array :) – Dmitry Malys Aug 17 '17 at 12:34
I like the pure laravel solution, although this should probably be in a nested where because of the amount of OR statements, to avoid confusion when adding more conditions – DarkMukke Aug 17 '17 at 12:41
Thank you. Give me some time to try it out – Dmitry Malys Aug 17 '17 at 12:48

score 0 · Answer 2 · answered Aug 17 '17 at 12:29

0

you can use as like be sure $chassis is an array

public function chassis($chassis)
{
    return $this->builder->whereIn('model_type_en', $chassis);
}

answered Aug 17 '17 at 12:29

D Coder

572
4
16

1

Although this solves the array to string conversion problem, he cannot use a wildcard like in w LIKE condition – DarkMukke Aug 17 '17 at 12:31
if you want to use whereIn() then no need to use LIKE – D Coder Aug 17 '17 at 12:32
but his question indicates he needs LIKE and IN – DarkMukke Aug 17 '17 at 12:34

DarkMukke · Answer 3 · 2017-08-17T12:38:38.967

0

What you are tying to do is a combination of an IN and a LIKE.

~~I would suggest RLIKE which is a LIKE but with REGEX. Although this is mysql specific, so I doubt there is a Laravel build in way to do this.~~

Update

Sadly I was mistaken, and though RLIKE could do it. Instead find your answer in this post here : Is there a way to combine IN and LIKE in MySQL?

edited Aug 17 '17 at 12:38

answered Aug 17 '17 at 12:33

DarkMukke

2,469
1
23
31

Array to string conversion in Laravel using 'LIKE' query

3 Answers3