Support the ongoing development of Laravel.io →
posted 9 years ago
Database
Last updated 1 year ago.
0

Why are you concatenating: "%"."tx_ard_users.uid"."%" ?

Last updated 1 year ago.
0

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

Last updated 1 year ago.
0

Just do "%tx_ard_users.uid%" :)

Last updated 1 year ago.
0

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.

Last updated 1 year ago.
0

Yes, this is right, im sorry

Last updated 1 year ago.
0

Thank you guys! You're great!

Last updated 1 year ago.
0

Great, thanks!

0

Sign in to participate in this thread!

Eventy

Your banner here too?

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2024 Laravel.io - All rights reserved.