When i have developed my first GAE application, i wanted to use a request with a “LIKE” to find all tuples beginning with a prefix. GQLQuery does not allow this kind of SQL request (SELECT * FROM user where name LIKE ‘SMIT%’). The solution is to use this kind of request:
query = self.request.str_POST['query']
queryEnd = query+"\xEF\xBF\xBD".decode('utf-8')
res=db.GqlQuery('SELECT * FROM User WHERE name>=:1 AND name<=:2 ORDER BY nom DESC', query, queryEnd)
I was obliged to modify the sample code provided by the documentation (here)
queryEnd = query+"\xEF\xBF\xBD".decode('utf-8') was added.
Thanks a lot to José Oliver Segura for his support.
Information can be found here