Using a value in a 'like'

[Kevin Jones]

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

[Alf Lervåg]

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

--
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.

[Kevin Jones]

Thank you,

I was missing the 'inline'

Kevin

[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,

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/b1315e86-63f8-4f26-afa2-92abb0ddbd23n%40googlegroups.com.

[Lukas Eder]

Hi Kevin,

In addition to Alf's suggestion, you could also just use Field.contains(Field)

I hope this helps,

Lukas

--