space is remove when i call concat in option
->form([
Select::make('mfm_member_id')
->label('Partner Name')
->options(function () {
return Contact::query()
->selectRaw("CONCAT(name, ' ', phone, ' ', ' ', email) as combined_data")
->addSelect('id')
->paginate(15)
->pluck('combined_data', 'id');
})
this is my code i want to add space but in option it does not show spaces
Select::make('mfm_member_id')
->label('Partner Name')
->options(function () {
return Contact::query()
->selectRaw("CONCAT(name, ' ', phone, ' ', ' ', email) as combined_data")
->addSelect('id')
->paginate(15)
->pluck('combined_data', 'id');
})
this is my code i want to add space but in option it does not show spaces
