ALTER TABLE `items` ADD FULLTEXT(`item_title`,`item_description`); SELECT * FROM items WHERE MATCH (item_title,item_description) AGAINST ('dog');