NYCPHP Meetup

[Tom Melendez]

> >
> >I'd like to know if anyone can recommend a book or whitepapers on
> >SQL for full text searching and storing.
>

Have you considered search engine software, such as mnogosearch?
You'll get all of the fancy heuristics (plurals, stopwords, page
element weight), URL indexing, query tracking, status code resolving
(what if the page is no longer available?), etc..

I realize that this isn't what you asked for and you probably aren't
building a search engine "proper", but you might want to check out a
search engine product anyway as it may resolve some of your
application issues for you.

Plus, mnogosearch has a PHP extension so you can talk to it directly,
get your results and display/use them as you like.

Good Luck,

Tom
http://www.liphp.org