Re: Using a value in a 'like'

[Alf Lervåg]

You could also have used val, but in this case I believe inline is correct.  Alf Lervåg 14. jul. 2023 kl. 23:00 skrev Kevin Jones <ke...@knowledgespike.com>: 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. -- 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. -- 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/B91502C4-CE25-42C6-A016-4E5009B67E4B%40lervag.net.