I love MySQL's FULLTEXT searches

You can spend a lot of time developing custom search solutions, but MySQL's FULLTEXT indexing is surprisingly good. Not sure why I'm surprised; it's a great DBMS, but still.

ALTER TABLE Items ADD FULLTEXT (Title, Creator);

Then, search it in a query:

SELECT Title FROM Items WHERE MATCH(Title, Creator) AGAINST ('software');

Guess it's been mentioned before.