I use the substring_index function in many case to output a certain number of paragraphs the following way:
SELECT description , SUBSTRING_INDEX( description, CHAR(13,10),3) AS first_paragraphs FROM content FROM
Now the following situation occurs. I need to output the first three paragraphs, followed by content coming from another table after which I need to output the last three paragraphs from the table content. In other words
Content from other table
Now I was wondering If there is a way to use the SUBSTRING_INDEX function as described above, with an addition of where to start (COUNT, START AT)?
Thank you in advance.