View Single Post

   
  #3 (permalink)  
Old 02-28-2008, 09:43 AM
lark
 
Posts: n/a
Default Re: Carrying out a full-text search, but without the full-text search...

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 -- hamzee@sbcdeglobalspam.net
To reply to me directly, delete "despam".
Reply With Quote