On May 1, 8:11 pm, lark <ham...@sbcdeglobalspam.net> wrote:
> Joachim Durchholz wrote:
> > Daz schrieb:
> >> I would like to create a wiki that will allow full-text
> >> searches.
>
> > Try a FULLTEXT index.
> > I have never used it, but it's supposed to do exactly what you want.
>
> > Regards,
> > Jo
>
> that's right. with a fulltext index you can do wonders however consider
> the limiations:
> 1-works only in myisam tables
> 2-collation dependent
> 3-no column prefixes apply (obviously)
>
> --
> lark -- ham...@sbcdeglobalspam.net
> To reply to me directly, delete "despam".

That's excellent. Thanks guys.

I didn't realise you could use a full text index. I assumed that
searching fulltext would be very heavy on resources.

Thanks again.