FN-FORUM: MySql Escaping -

date posted 17th October 2006 10:43

A little problem I have.

I want to search for the following string in a FullText index

Weston-Sub-Mare

I know the Table contains many entrys, and they will get returned if you
search for just Weston.

The problem is the - is excluding the sub and mare. If I escape the -
with \- it still doesn't work..

Any thoughts, any one?


TIA

Chaz