Published July 1st, 2003 by Jim O'Halloran
Full Text Searching in MySQL
ONLamp.com has a good introduction to MySQL FULLTEXT Searching…
MySQL has had FULLTEXT searching in one form or another since version 3.23.23. FULLTEXT indices in MySQL allow database administrators and programmers to designate any character-based field (CHAR, VARCHAR, or TEXT) as a FULLTEXT index, which allows for complex text searching against data stored in those fields.