Hi Tuan, I'm sorry, I'm not sure I understand what you mean. Can you show a more specific example with some example data?
On Tue, Feb 23, 2021 at 4:47 PM Tuan Quoc <[email protected]> wrote: > Hi Lukas, > > I am trying to implement Contains(field, value) by using > DSL.field("fieldName").contains("value") and it will be generated like > this: > fieldName like ('%' + replace(replace('"value*"'), '!', '!!'), '%', '!%'), > '_', '!_' + '%') escape '!' > > When I run the query with Contains(fieldName, value), there are multiple > rows affected but when I tried running the generated query above, there is > no rows affected. > > Do you have any solutions for this? > > Thanks a lot in advance. > > Thanks > Tuan > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/839db656-4869-4df0-aa92-5e39a6d7cc1fn%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/839db656-4869-4df0-aa92-5e39a6d7cc1fn%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO6VDTYt7COk2_TgmzADuTXUnqi_KywOtnz9Kjvi-45PHA%40mail.gmail.com.
