java - "LIKE a%". How to write this on app engine? -

i'm using java app engine. sql query:

select * person name "a%"

how write on google app engine?

there's no support operator in appengine's datastore.

two solutions :

• use google cloud sql if want keep sql-like queries
• use full text search entities in datastore