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.

Reply via email to