Surprisingly something of this quality has not been presented to me in some time, but Cal does a great job of going through the steps in an understandable fashion. When I saw the first SQL statement I knew there had to be more going on there and I was right as I continued reading further down.

I really like how Cal goes into the details of possible searches that can be done on your site and takes the measures to erase any malicious html formatting (and the like) that may be done on the site.

The best part is that he doesn’t stop there and continues on with another article that features Search Term Highlighting. Very nicely done.