How do you do a 'like' query in appengine JPA?

Question

I know there is a limited version of a LIKE query in the App engine's datastore where you can only search on the end of a string but I can't seem to find the syntax.

I want to do something like this

SELECT * FROM MyTable WHERE name LIKE ji%

Answer 1

See this question: http://stackoverflow.com/questions/47786/google-app-engine-is-it-possible-to-do-a-gql-like-query