Thank you,
I was missing the 'inline'
Kevin
On Friday, July 14, 2023 at 7:06:14 PM UTC+1 Alf Lervåg wrote:
> I don’t have my computer handy, but yes thats pretty simple in jOOQ.
> Something close to:
>
> ctx
> .selectFrom(A)
> .join(B)
> .on(A.Name.like(concat(inline('%'), B.Name, inline('%')));
>
> Note that it is unlikely that your database will be able to use an index
> for this join, so be certain your datasets don’t grow too big here or
> you’ll have bad performance.
>
> Alf Lervåg
>
> 14. jul. 2023 kl. 18:32 skrev Kevin Jones <ke...@knowledgespike.com>:
>
> I have SQL something like this
>
>
> SELECT * from A
> join B on A.Name like CONCAT ('%', B.Name, '%")
>
> Is that possible in JOOQ?
>
> Thanks,
>
> Kevin
>
> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to jooq-user+...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/jooq-user/b22e6d9d-49ab-4cc9-aa57-12ba3e61cbbfn%40googlegroups.com
>
> <https://groups.google.com/d/msgid/jooq-user/b22e6d9d-49ab-4cc9-aa57-12ba3e61cbbfn%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to jooq-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/b1315e86-63f8-4f26-afa2-92abb0ddbd23n%40googlegroups.com.
