[plug] mysql question

[James Devenish]

In message <Pine.LNX.4.44.0409241724590.14253-100000 at guild.murdoch.edu.au>
on Fri, Sep 24, 2004 at 05:27:18PM +0800, Shayne O'Neill wrote:
> Assuming I have a full text index (according to phpmyadmin) against all
> the correct fields, is there anything wrong with;-

By the way, MySQL will complain bittery if you do not have the correct
indices. If the query succeeds without generating an error, I'd guess
that you have set it up okay.

Also: I would normally assume that if you add a full-text index
retrospectively, MySQL would generate the index en bloc (as it would do
with any other index). However, if you have added the index after your
table was already populated, perhaps you should check to see if you have
to trigger MysQL to rebuild the index.