How to substr() longtex type data OR Triming longtex type data?

Hi friend,

I have long data (text/html) in my mysql table's longtext type field. I can retrieve and display that data using php.

But I don't want to display full data from that field. I want to display a portion of data from that, suppose 30% data. How can I do that?

If trimming/cropping data is not possible in percentage then can it possible using substr() function? But I found substr() doesn't work in long text.

Can you please help me?

Thanks

from PHP https://ift.tt/2SgXLdj
via IFTTT