Could anyone please give me a hand?
You'd need to generate the "title-of-post" part for each post and save it in a separate column (and then apply some UNIQUE INDEX to it).
That may not be an easy task when considering the chances of two posts with the same title and changing the "title-of-post" column along with any change in the original title of the post.
The easy way is to make the urls like www.mysite.com/1_title-of-post
and then extract the id from url to retrieve it from DB.