Substring_index

Databases
1

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.

2

no no error it just shows the entire text

3

Do you get an error, or what?

4

no, it doesn’t