MySQL — how do I get from the database from column a certain number of characters, but without the tags?

I want to get, for example, 300 characters. This is a preview of the article. To read the entire article, you need to go to the page with it (open it). The problem is that the database can be used text tags. In php I take them off (strip_tags). But it turns out less than 300 characters. As I understand it, you need to remove them when retrieving data. How can I do it? Help to write a query.
June 10th 19 at 14:47
3 answers
June 10th 19 at 14:49
Solution
Wrong answer: Get more and crop
Correct answer: When you save create in database an additional property already brushed it long.
And if you want to change this length? Or will another card, for example. With another length of article preview. What then? To sort the entire table? - melvina_Rolfs commented on June 10th 19 at 14:52
store the full text ideally, a difference of 10 KB in the database it is not serious, and the breakdown of the text in the middle of the tag will give you much more hemorrhoids. - lily.Kozey commented on June 10th 19 at 14:55
you can store the full article, but naked, without images and tags. By the way, is a field with a text copy of the article can be used not only for output previews and to search. - Tod commented on June 10th 19 at 14:58
June 10th 19 at 14:51
The easiest way to query from the database with a stock, clean and trim already in the script.
I don't know how many tags... How much stock should be. All the text that you request? Not much resources will that take? - melvina_Rolfs commented on June 10th 19 at 14:54
June 10th 19 at 14:53
Well, you can write a function in SQL that will strip tags, identifying them by the corner brackets. The specific implementation depends on the SQL dialect, well, hardly anyone will take it free to do... though, you can search on the Internet ready. Although, I agree with

Find more questions by tags MySQLSQL