I am looking into full-text search functionality. For example: a text like
Sky is beautiful today and sun is out.
My search requirement is : Find text that “Begins with Sky and ends with out”.
What would be the best way to write a search query to achieve this?