I need to index the "once" word

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 help me?

Thanks.

Re: I need to index the "once" word

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/en/fulltext-fine-tuning. html (in the
paragraph starting, "To override the default stopword list")

http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html
(about "ft_stopword_file" option)

Regards,
Bill K.

Re: I need to index the "once" word

Thank you Bill.

Mi index it's ok :)

Best regards.

Bill Karwin ha escrito:

> D=E1maso Vel=E1zquez =C1lvarez 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/en/fulltext-fine-tuning. html (in the
> paragraph starting, "To override the default stopword list")
>
> http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html
> (about "ft_stopword_file" option)
>=20
> Regards,
> Bill K.