How to create this Query?

First study the LIKE syntax:

https://dev.mysql.com/doc/refman/8.0/en/pattern-matching.html

@JLRDW - Query returns the result what i want in mysql terminal, but not in laravel

Post here what you tried, just me, I don't like clicking links.

@JLRDW - Ok 😶

@JLRDW - $houses = House::whereHas('property', function($query) use ($keyword,$room) { $query->where('noOfRooms','>=', $room);

    })->whereHas('property',function($query) use ($keyword){
        $query->orwhere('postalCode', 'LIKE', $keyword)
              ->orWhere('province', 'LIKE', $keyword)
              ->orWhere('city', 'LIKE', $keyword);
    })

@NANOX - What is the value of $keyword? Does it look like this...

$keyword = '5%'

Do you want everything starting with 5? Do you want everything between 50000 and 59999? You might need to look a SQL syntax similar too..

where (postalCode >= 50000 and postalCode <= 59999) or (province >= 50000 and province <= 59999) or (city >= 50000 and city <= 59999)

... or .... perhaps something like this...

where postalCode like '5%' or province like '5%' or city like '5%'

@RKRITE - No i just need, %50000%

Keyword may be different, I'm building a search box, And I use a single input box, user can enter a postal code, city or province name,

I fixed the query :P

})->whereHas('property',function($query) use ($keyword){
            $query->where(function($query) use ($keyword){
                $query->orwhere('postalCode', 'LIKE', $keyword)
                      ->orWhere('province', 'LIKE', $keyword)
                      ->orWhere('city', 'LIKE', $keyword);
            });

Thanks <3