Need proper full-text searching | Calvin Hymnary Project

Project:	Hymnary
Component:	Code
Category:	feature request
Priority:	minor
Assigned:	Unassigned
Status:	fixed

I just searched using the phrase "savior like a shepherd" and got no results. Of course, I got the hymn I wanted when I typed "savior, like a shepherd." Can we allow searching by words rather than exact phrase? There are so many hymns that contain commas, colons and exclamation points in places that one wouldn't expect that it's unrealistic to expect users to know the correct phrase. We also need to account for variations in titles between hymnals and user spelling errors.

Updates

Some day we may want to do a full-text, fielded search engine using lucene.

Mysql apparently supports a full-text indexing method in MyISAM tables:
"The MyISAM storage engine currently incorporates three indexing methods: BTREE, RTREE, and FULLTEXT. Normally, BTREE indexes are used. RTREE indexes are used for indexing geographical (GIS) data, and FULLTEXT indexes are specifically tailored to the MySQL full text search system."

Perhaps there is a way to use a MyISAM or another MySQL storage engine to support google-like full-text searching without much difficulty.