Hello, This expression here:
BOMODULES.BOPATH.like(path) ... is really just short for this one: BOMODULES.BOPATH.like(DSL.val(path)) So in other words, to inverse the LIKE predicate, just inverse the Fields: DSL.val(path).like(BOMODULES.BOPATH) Please refer to these pages of the manual for more details: http://www.jooq.org/doc/3.3/manual/sql-building/bind-values/ Cheers Lukas 2014-05-07 17:34 GMT+02:00 <[email protected]>: > Hello, > > it is maybe a stupid question but how i can construct a sql like that : > > select idbomodules from bomodules where '/p/r/Yb!je7!XW5*aIX!!!P3I!!' > like bopath > > => > dsl.select(BOMODULES.IDBOMODULES).from(BOMODULES).where(BOMODULES.BOPATH.like(path)) > > if i do that it constructs that : > > select idbomodules from bomodules where bopath like > '/p/r/Yb!je7!XW5*aIX!!!P3I!!' > > and the sql result is not the same because i have in bopath data this kind > of data => /p/r/% > > thanks in advance > > -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
