I'm doing a search system for my blog (it already looks for post category and tags). Is there any SQL command (or if SQL itself already does this) that makes it check all the contents of the data found in the table and return me?
Ex: I put a "test" tag for my post and look for "test" it will return me the right post (because they are N tags for 1 post). Now, if I put the content of the post (or the title) "I'm doing a test", will it search the "test" there in the middle of the other words?
Is there a way to do this or will I have an explode in the search results to search word for word?