I am trying to implement a preview for various articles, the preview should be a small part of the full article to give the reader and idea of the content.
My current solution is to load all content as text and display it in a div with a max-width of 300px
and overflow hidden. While this does work it does not seem like the best solution.
I though that maybe selecting a part of the content using mysql would be an option. How would I approach getting a preview, should I just get N characters or does MYSQL have more tailored functions for this behaviour.