Search API, how to like query

Question

I'm using the Search API GAE, how to make a query like "like%"? as is done in SQL example: select * from person where name like '% john%';

I want to do a search using the search service (Search API) like this in SQL: select * from name like '% jo%'; (return john) — Joander Vieira Cândido, Sep 08 '13 at 14:24

Ashish Awasthi · Accepted Answer · 2013-09-23T08:05:52.687

1

your queryString would be "name: john" on the person index with name field set to be a Text field.

A regular query with ':' or '=' on the Text or HTML type of index value is closest (not same) to 'like' in SQL.

edited Sep 23 '13 at 08:05

answered Sep 08 '13 at 04:49

Ashish Awasthi

thank you, I'm Brazilian I'm using google translator.But if your putting "name: jo" (similar to "like '%jo%' ") returns no data – Joander Vieira Cândido Sep 08 '13 at 14:11
Joander, I don't think "like '%jo%'" kind of queries are supported in GAE-search yet, you may raise a ticket to add it though. Or else you can go to your database for these. GAE-search is primarily designed to work on the context and it uses tokens (whole words). What you can do though is stemming, if your use-case is to find words with similar meaning. https://developers.google.com/appengine/docs/java/search/query_strings#Java_Stemming – Ashish Awasthi Sep 09 '13 at 12:07

1 Answers1