> Ya the main thing is I wanted a condition but it needed to be in parentheses > before hand. I am making my code build complex sql queries and I needed the > parentheses for one function that returns a condition. It is hard to explain > but the main thing I am missing is something that I can use to put > parentheses around a condition. > > the condition that gets returned get passed in > countselectconditionstep = > countselectconditionstep.and(searchfilter(querytags).or(hiddenkeystringfilter));
I'm not sure where you would want to add parentheses? There shouldn't be any need to put extra parentheses around any conditions. jOOQ puts the necessary parentheses where needed. Regardless of the outcome of your analyses, your query is quite complex and probably rather slow. Have you considered using MySQL's full text search features instead? http://dev.mysql.com/doc/refman/5.6/en/fulltext-search.html Cheers Lukas
