've been working on an app that involves searching the database, im using LIKE, something like:

"select * from news where headline like '%$search-term%' or content like '%$search-term%' "

I found out that LIKE is only good for one-word searches.--Returns results for good day but not for day good- though good and day exist in the database (but not in that orderand I didnt surround the search term with quotes).-Also if searched for good day will produce results but search for "good day" will not produce results.Generally, quotedterms do not produce any results.

How do I break up the search to make the script search for individual wordsin the search term in any order of appearance and to search for quoted terms or is there a more professional searh method other than LIKE?