??? What does that mean??? I can only assume you are trying to get product descriptions with the string "M&S" in them?
I am - however I cannot use 'like' - I have to use match against and the ampersand is being interpreted as either a logical AND or as a parameter so I need to escape the ampersand in the against clause. The example I used is extremely simplistic but should give the essence of what I am trying to do.
Escaping a character means replacing it with an escape character so the query processor does not get confused - for example wanting to find the occurence of a directory structure you have to escape the \ by using a \\. However I cannot find how to replace the ampersand in the against clause, as it works different to the like clause. An ampersand in like does not need escaping, however in against it does.
Ah sorry about that. You just introduced me to the boolean mode option. I thought you were just trying to find things like 'M&S' and didn't read that you can't use the LIKE operator .
Aaaanyways...I thought you couldn't use match against with such short strings? If you're using longer strings, can't you encapsulate the terms in double quotes to deal with the special characters? As far as I've read it seems like this is the case?
the ampersand is being interpreted as either a logical AND or as a parameter
Hmmm...what is your environment? I just tried running some queries with the '&' character and they seemed fine. Without using double quotes too...Maybe it is just the length factor???