MySQL order by field in Criteria API
Here I have a simple example showing how to implement MySQL's order by field in Criteria API for MySQL DBMS.
MySQL fulltext search with JPA
Example on how to write JPQL or Criteria API queries for DB functions with 'unusual' signatures, like MySQL's FTS function - match against.