I'd like to show a "featured" post on the front page [on a WordPress install]. The idea is to take the first post in the thread, show the content, and link to the thread.
I guess this could become a plugin but for now just the MySQL would be a start and this placed in the theme's front page.
Thank you in advance.
[update for clarity]