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"?

user_513710 · Answer

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

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

That should do the trick.

user_1276523 · Answer

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.