Re: Full text search and highlight results

2008-09-09 Thread lbarcala
> MySQL has no idea how you are presenting the data (html, rtf, etc.), > so it couldn't hilight the words for you. It should really be that > tricky using grep and PHP. > > Brent I have my data as pure text: no html, rtf or something else. That is, one table with two columns: one for the document

Ignoring some characters to build FULLTEXT index

2008-10-21 Thread lbarcala
Hi all: I am trying to build a FULLTEXT index with several particularities. It must ignore some special characters inside index words. For example: If I have the text: I'll go to the ci[ne]ma. I want the FULLTEXT include the word cinema, not ci[ne]ma nor ci or ne or ma. So, I want the index ign