Whit the help of Rudy I could output a first Paragraph from a long text using:
SUBSTRING_INDEX( product_description, CHAR(13,10), 1) AS first_paragraph
For a multiple language site I needed to change that into:
SUBSTRING_INDEX( product_description_eng, CHAR(13,10),1) AS first_paragraph_eng
SUBSTRING_INDEX( product_description_gre, CHAR(13,10),1) AS first_paragraph_gre
SUBSTRING_INDEX( product_description_dut, CHAR(13,10),1) AS first_paragraph_dut
and so on. But now can't I get just the first paragraph to display? I quess it has to do with the CHAR(13,10) but I'm not sure. Can someone please explain what I'm doing wrong and if it indeed has to do with the CHAR(13,10) part of the SUBSTRING_INDEX, please explain me the working of that part
Thank you in advance.
no no error it just shows the entire text
Do you get an error, or what?