When do escape for , in the search term?

[Zeus]

I have the data as follows,

(jerry,scott, new-test@sf.gov.juryduty,sofia@casecentral.org)

I want to search for FIELD1 literally like jerry,scott

i.e. jerry followed by comma and the word scott.

[mark]

Use \,
(jerry\,scott,new-test@sf.gov.juryduty,sofia@casecentral.org)

And don't put any spaces around your commas.

[Zeus]

Thanks.
More specifically,
when and how do I escape non alphanumeric characters in the search term.
For example,
search for '(jerry,scott)' (literally as a phrase).
search for 'jerry,scott' (literally as a phrase).
search for '(jerry,scott,new-test' (literally as a phrase).
search for 'jerry,scott,new-test@sf.gov.juryduty' (literally as a phrase).
etc..

thanks!!

[mark]

See if this thread answers your questions
http://thunderstone.master.com/texis/ma ... 417d51af10

[Zeus]

Thanks, that helped!
But, still the following kind of searches, I could not run properly,

search for "#1,zeus@scooby.com"
that is a literal search.

I tried,
FIELD1 like "\#1,zeus@scooby.com"

but, I get hits that have just zeus@scooby.com along with the correct hits.(looks like doing an OR search)

same is the situation with,

FIELD1 like "\@50.25,start@yahoo.net"

thanks!!

[mark]

I'm not sure why off the top of my head, but that needs to be "\#1\,zeus@scooby.com" and "\@50.25\,start@yahoo.net" . Probably something about the special char on front.