Search concatenated columns in MySQL while Ignoring NULL values

search_concatenated_nullable_columns.php

<?php

public function scopeSearch($query, $search)
{
    $search = addslashes($search); // in case the search has quotes
    
    $query->when(
        $search,
        fn ($q) => $q->whereRaw(
            "CONCAT_WS(' ', title, first_name, last_name, suffix) LIKE '{$search}%'"
        )
    );
}