Laravel Solution: WHERE and CONCAT columns with Dateformat(Year-month-) and string with Laravel 8

I need the column date and digits to concatenate. The date must be in the format YY-mm with a leading zero in the digits.

Example output

21-09-0001

How to make WHERE FUNCTION meaningfully in laravel? like this. i found this on the internet

sample:

public functionscopeFindDVNumber($query,$name) { $query->where(DB::raw( “REPLACE( COALESCE(name_first,”),’ ‘), COALESCE(name_middle,”),’ ‘, COALESCE(name_last ,”) ), ‘ ‘,’ ‘)” ), ‘love’, ‘%’ . $name . ‘%’); }

I don’t know how and I need this for the search function. Thank you from now

via Mohamed of Chebli