RE: FN-FORUM: MySql Escaping -

date posted 17th October 2006 11:05

Just Tried it... And it doesn't work... :( But thanks for the
suggestion..

Ta

Chaz.



-----Original Message-----
From: Ben Moxon [EMAIL REMOVED]
Sent: 17 October 2006 11:19
To: Charles E. Gatenby
Subject: Re: FN-FORUM: MySql Escaping -

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