How to the @ symbol in RediSearch?

Question

I'm using the modules RedisJSON and RediSearch together to perform search queries on JSON data. Given a json list like this:

{"email": "test1@example.com", "is_checked": 1}

I do:

FT.CREATE myidx ON JSON SCHEMA $.email AS email TAG
FT.SEARCH myidx "@email:'test1@example.com'"

but I got Syntax error

How can I select with the value "test1@example.com"?

score 2 · Accepted Answer · answered Feb 03 '22 at 18:03

2

You can escape special characters, like @, with a backslash:

FT.SEARCH myidx "@email:'test1\@example.com'"

That should do the trick.

answered Feb 03 '22 at 18:03

Guy Royse

1

Full details on when to use escaping here: https://oss.redis.com/redisearch/Escaping/ – Pieter Cailliau Feb 03 '22 at 22:23

score 2 · Answer 2 · answered Jun 03 '22 at 23:30

2

I just ran into this issue and the accepted answer didn't work for me, but I found a solution in this RediSearch issue.

With an index where there's an email field stored as a TAG you can do a search like this:

FT.SEARCH myidx "@email:{ test1\\@example\\.com }"

With the @ and . characters escaped.

answered Jun 03 '22 at 23:30

jket

This is the correct answer, as it prevents the tokenization of the value on the '.' and properly uses the '}' since the field is defined as a TAG. – Robin Mar 30 '23 at 15:39

2 Answers2