GQL: Find all entities that contain a substring

Question

I have some entities that have a StringProperty and I would like to query for all the entities that match a substring. Is there a way to do that using just GQL?

For example, if my datastore looks like this:

ID/Name     question_text
--------------------------------------------------------------
3001        I like to eat chicken.
3020        I only like to eat chicken that is deep fried.
3045        I like filet mignon.
3052        I like cheese.

What would the GQL query be to find all the entities that contain 'chicken' in question_text?

Your answer is in [this post](http://stackoverflow.com/a/47811/5517975). :/ — afrodev, Dec 05 '16 at 18:04

score 3 · Accepted Answer · edited Jun 10 '13 at 11:30

3

What you're looking for is full-text search over a StringProperty. This is what SearchableModel was created for.

Basically, it creates a new property on your entity that is a list of all the strings (and I believe bi- and tri-grams) in the text field, using the task queue. Then searching for "chicken" is done by a GQL query like SELECT * FROM whatever WHERE 'chicken' IN strings_list

edited Jun 10 '13 at 11:30

alecxe

414,977
106
935
1,083

answered Jul 03 '10 at 17:58

Jason Hall

19,881
4
47
56

2

Just for clarification, this will only work for **full words**, so searching for "chicke" won't return anything given your example data. – Jason Hall Jul 03 '10 at 18:11
Could you please give an example that WOULD work for "chicke"? – DarkMatter Jan 31 '17 at 03:03

GQL: Find all entities that contain a substring

1 Answers1

Linked