I'm guessing that this is about MySQL? Have a look at MySQLFactory, then: http://www.jooq.org/javadoc/latest/org/jooq/util/mysql/MySQLFactory.html http://www.jooq.org/javadoc/latest/org/jooq/util/mysql/MySQLFactory.html#md5(org.jooq.Field)
Cheers Lukas 2012/11/21 Ben Hood <[email protected]>: > Hi, > > I was wondering whether there is a factory method to call an MD5() string > function in a query. Natively I was thinking of the following SQL: > > select year(some_date), md5(group_concat(some_column)) > from some_table > group by year(some_date) > > The generic Factory class offers functions to generate year() and > group_concat(), but I couldn't see one for md5(). > > How should I proceed? > > TIA, > > Cheers, > > Ben
