Doing Relevance Ranked Full-Text Searches In MySQL

I’m going out on a limb to say MySQL’s full-text indexing and searching features are underused. They appeared in MySQL 3.23.23 (most people are using 4.x, and 5 is in development), but it’s been news to most of the people I know.
Here’s the deal, the MATCH() function can search a full-text index for a string [...]

Full-Text Searching Inside Books

Search Engine Watch did a story about how to use Google and Amazon’s tools to search full-text content inside books.
The gist? when you can get to the tools and where they’ve got content, it does a lot to make books as accessible and open as electronic content.
Sort of related: I’ve spoken of Google Print before [...]