Why are you concatenating: "%"."tx_ard_users.uid"."%" ?
Hmmm... I thought I had to do it this was to have the value between %% as it is a LIKE... do you have a better idea? I'd be glad! :-D
I think that in fact you need to concatenate
...
$join->on('tx_ard_researches.incharge', 'LIKE', DB::raw( "CONCAT('%', tx_ard_users.uid, '%')
" ))...
Not sure of %
and performance of this query though, depends on your needs.
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community