Need help creating a mysql query in PHP

Hi, I have a form containing a text field where the user types in a sentence. I need to search a mysql table, specifically a text field and display a list of found results. My criteria selections are: 1) return a record if all the words are contained in a record 2) return a record if all any word entered are contained in a record 3) return a record if parts of all words (starting at the beginning) are contained in a record (e.g.. 'ex is in 'exercise') 3) return a record if parts of any word (starting at the beginning) are contained in a record (e.g.. 'ex is in 'exercise') Any advice would be appreciated. Thanks, Don