Now With Search Functionality
2010-05-20
I've added a search function to my blog! Rob was looking for something the other day and was upset to find I didn't have a way to search my posts. So I've added one. You can access the search field in the menu, between the random quote and the random photo.
Implementing the search was super easy! Apparently MySQL has built in full-text search capability. You can mark text columns in your tables and they will be indexed. Then you can add match conditions to the "where" clause of queries on the database. It works really well and returns results sorted by relevance. It's awesome!