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.

I have a database table with a field called "status" which can take on a number of different values. I want to also record whenever that status changes so we have a "Last status change time" record ...