I want to make this column searchable. Is there a way to achieve it?
I can only think of joining the tables in the Eloquent query and change the column definition using a case statement. But that is rather messy and would like to have a cleaner solution, if available.