Re: FN-FORUM: MySql Escaping -

date posted 17th October 2006 10:53



Charles E.Gatenby wrote:
> 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?
>
What about using a wildcard - you could probably get away with
'Westion%sub%mare' in a like statement although it might also bring back
"Weston was the name of a submarine nightmare" or possibly
"Westion_sub_mare" where the "_" will apparently match only one character.

Not used it, because I only just found out it exists, but that might do
the trick quite nicely...

-ben