However, note that MySQL does not include stopwords in the FULLTEXT index
--and it currently considers any word of three characters or less to be a
"stopword". So if you really are searching for words as short as "cat",
this isn't the solution (or else you're going to need to make some
modifications to the MySQL source and re-compile).
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Clarence) wrote:
> Try "MATCH (FULLTEXT index columns) AGAINST ('keyword')"
>
> Check the MySQL manual at: <http://www.mysql.com> and search for "match
> against" or "fulltext"
> You need to build FULLTEXT indexes on the columns you want to search
> before you can use the above syntax.
>
> However, it will search and sort by relevance.
>
>
> On Thursday, April 19, 2001, at 09:56 AM, Jen Hall wrote:
>
> > Hi there
> > I have some scripts that do a search in a MySQL database
> > table.
> > I want to be able to return rows that match a query, in
> > order of relevancy.
> > For example, say I have a table that has the following data
> >
> > |row_id| data
> > |------|-------------------------------------
> > | 1 | cat
> > | 2 | cat cat
> > | 3 | cat cat cat
> > | 4 | cat cat
> > | 5 | cat cat cat cat cat cat cat
> > | 6 | cat
> > | 7 | cat cat cat cat
> > | 8 | cat cat cat cat cat
--
CC
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
