Search engine mechanism with multiple arguments
You can use full text search for this
http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html
This will help you alot.
Note: Table should use MyISAM Storage engine and column should be full text indexed.