Hello Matthew
I would be quite interested to know how you managed to make a
partial search. I built a search engine recently using fulltext, and
partial searches would never work. Say I type in child, I would never
get any results with children.
This is quite weird since you seem to want it the
If you searched for '% john %' - note the spaces, you would not find
'johnson' etc..
-Original Message-
From: Matthew Brealey [mailto:[EMAIL PROTECTED]]
Sent: Tue, 26 June 2001 11:29
To: [EMAIL PROTECTED]
Subject: Full text search gotchas
We're having quite a lot of difficulty with
At 13:53 +0200 2001-06-26, Bruce Stewart wrote:
If you searched for '% john %' - note the spaces, you would not find
'johnson' etc..
*Sigh* Since when do wildcards work with the fulltext index?
Besides, there are characters beside a space wich can delimit words.
Three examples: Commas. Line
Hello,
thanks for your reply. I was wondering...I thought the LIKE function
is only for single words? I have to admit I never tested it and started
right off with fulltext option.
So would following work then...
Lets assume one entry in somefield is: The children are playing on the
play-ground
PROTECTED]
To: Sebastiaan J.A. Kamp [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 2:31 PM
Subject: Re: Full text search gotchas
Hello,
thanks for your reply. I was wondering...I thought the LIKE function
is only for single words? I have to admit I never tested