How to search @ | & ( ) in sphinx

Question

How to search @ | & ( ) in sphinx.

I want the results contains these symbols, it is keyword for sphinx, how should I search these stuff?

thanks

Answer 1

You need to escape those characters by inserting a '\' before it, or use Riddle.escape(string). Here is an related issue one github: https://github.com/freelancing-god/thinking-sphinx/issues/235

Answer 2

To be able to search by this characters you need to add them into charset_table, see charset_table documentation

And of course you need to escape them in search query, like:

$sphinx->Query($sphinx->EscapeString("my@email.com"));