Search engines are integral features to any well designed website, but how well does your search engine work? Most simple search engines work by querying one column of a database for the search terms.
CREATE TABLE `transaction` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` char(1) NOT NULL DEFAULT 'T', `TrxRef` varchar(30) NOT NULL, `TrxType` varchar(20) NOT NULL, `TrxDate` date NOT NULL, ...