My apologies, I didn't clarify that I *was* using a full-text search.
-----Original Message-----
From: Lindsay Adams [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 11:52 AM
To: [EMAIL PROTECTED]
Subject: Re: Full Text Search Question
To do a full word match like you are wanting, you would need to break up the
sql query to do this:
... WHERE field LIKE "%word1%" AND field LIKE "%word2%" ...
That is how you have to do it if you are not using one of the latest 3.23
versions of mysql. If you have a newer version of mysql, check out this
page for more info
http://www.mysql.com/doc/M/y/MySQL_full-text_search.html
On 4/3/01 11:07 AM, "Oson, Chris M." <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a site that I'm trying to implement a search engine on existing and
> archived news stories on a medium text datatype in a database.
>
> I read the documentation and got it running, but unless I missed something
> it's not doing what I want it to do.
>
> For example, if I put in the keywords [Alpine Fire], it will return all
> stories with Alpine Fire in it. That is what I want, but if there's
> another story about a fire, the search will return that also. Or if
> there's a story about an incident on Alpine street, that will also
> be returned.
>
> What I want is only stories that contain the keywords [Alpine Fire]. Is
> there a way to do that with a full text search? I'd rather not have to
> do a search using [LIKE '%Alpine Fire%'] because that doesn't seem like
> the most efficient way to do a search.
>
> chris
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php