I would like to search text for words prefiexed by $.
Sample records (table with 3 rows):
This is my string containing the $word special word.
Again $word is here.
My special $word must be found.
Example RoR (thinking sphinx):
MyModel.search '$word'
I get no results but if I search for '\$word' the word is found.
How can I fix that?