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.