title: calling a mysql function returning varchar in hibernate
body: <p>I am trying to use mysql <code>find_in_set</code> string function in hibernate but unfortunately I cant able to use it and even tried by creating these register functions </p>
  
  <pre><code>registerFunction("findInSet",newSQLFunctionTemplate(Hibernate.STRING,"FIND_IN_SET(?1,?2)"));
  registerFunction("findInSet",newSQLFunctionTemplate(Hibernate.INTEGER,"FIND_IN_SET(?1,?2)"));
  registerFunction("findInSet",new StandardSQLFunction("find_in_set", Hibernate.INTEGER));
  </code></pre>
  
  <p>using mysqldialect but no one is working..can any one please tell me how to use the mysql string functions in hibernate. or any changes to the above register functions.</p>
  
  <p>Thanks in Advance,</p>
  
  <p>Best Regards,
  Raja.</p>