Redisearch: [enhancement] Support substring search similar to SQL `LIKE '%foo%'`

[xevix]

Prefix search already exists such as pho*. It would be great to be able to match any substring, similar to SQL's LIKE '%pho%' which is a common use case for search.

Example proposed behavior

FT.CREATE myIdx SCHEMA title TEXT WEIGHT 5.0
FT.ADD myIdx doc1 1.0 FIELDS title "home iphone"
FT.ADD myIdx doc2 1.0 FIELDS title "the dome"
FT.SEARCH myIdx "*pho*"

Output

OK
OK
1) (integer) 1
2) "doc1"
3) 1) "title"
   2) "home iphone"

[mnunberg]

@itamarhaber Don't we already have this? no we don't. We have a %foo% syntax, but that's more about levenshtein distance matching than suffix/prefix matching

[jameycai]

It would be great to be able to match any substring, similar to SQL's LIKE '%pho%'

[Nomafin]

Is this going to be implemented in the near future? Would be exactly what I'd need for my project.

[mnunberg]

Hi, we plan to implement this at some point. “Near future” is a relative term, but it basically involves allowing suffix searches as well (e.g. “*foo”)

On Sep 2, 2019, at 4:40 AM, Miika Arponen [e-mail] wrote:

Is this going to be implemented in the near future? Would be exactly what I'd need for my project.

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub https://github.com/RediSearch/RediSearch/issues/348?email_source=notifications&email_token=AADKOUNLIJN4FC2S2LSSA7TQHTGOHA5CNFSM4FC6NKXKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD5VELHI#issuecomment-527058333, or mute the thread https://github.com/notifications/unsubscribe-auth/AADKOULS3VL7CW3QFFHRDTLQHTGOHANCNFSM4FC6NKXA.

[Nomafin]

Any update on the schedule of this? Our use case wouldn't even require this exact feature to be as blazing fast as all the other queries are, so even if it's some rugged alpha version, I'd be willing to give it a try.

[Karthik-Gupta]

Hey @mnunberg, just checking when can we look up to this feature? awaiting for this particular one in-order to incorporate RediSearch as our secondary indexing mech.

[kalyashov]

Hey @mnunberg! 2 years have passed since the issue was opened. This feature is also required in our project. Is there a deadline for implementing this feature?

[23233]

@mnunberg hope add this feature~ thanks! up up