Hi!

I am working with mysql server 5.0 an I have an Index in a database
table,

but I need to index the word 'once'. My index it's not indexing it
because once is a number... How can I configure Mysql or the index to
index this word?

My index is Fulltext type.

anybody can me?

Thanks.

Dámaso Velázquez Álvarez wrote:
> but I need to index the word 'once'. My index it's not indexing it
> because once is a number... How can I configure Mysql or the index to
> index this word?

It's probably a stopword. You can set the server option
ft_stopword_file to the path of your own custom stopword list.

See also:

http://dev.mysql.com/doc/refman/5.0/...ne-tuning.html (in the
paragraph starting, "To override the default stopword list")

http://dev.mysql.com/doc/refman/5.0/...variables.html
(about "ft_stopword_file" option)

Regards,
Bill K.

Thank you Bill.

Mi index it's ok

Best regards.

Bill Karwin ha escrito:

> Dámaso Velázquez Álvarez wrote:
> > but I need to index the word 'once'. My index it's not indexing it
> > because once is a number... How can I configure Mysql or the index to
> > index this word?
>
> It's probably a stopword. You can set the server option
> ft_stopword_file to the path of your own custom stopword list.
>
> See also:
>
> http://dev.mysql.com/doc/refman/5.0/...ne-tuning.html (in the
> paragraph starting, "To override the default stopword list")
>
> http://dev.mysql.com/doc/refman/5.0/...variables.html
> (about "ft_stopword_file" option)
>
> Regards,
> Bill K.