Optimizing search for google type search

Optimized and fixed search query which required stored procedure call and use of regular expression match to yield results. Implemented ability to search for words such as [space]test[space] but not fattest. Recommended differences and problems with using ft-search and transactions, which helped client to decide between myisam and innodb table types for the table to be searched.