Извлечение части данных из текстового поля

-- Первые сто символов.
SUBSTRING(`pd`.`products_description`, 1, 100),

-- Первые два абзаца, если они разделены двумя переносами строки.
SUBSTRING_INDEX(`pd`.`products_description`, "\n\n", 2)

$query = "select
            p.products_id,
                        p.products_ean,
            pd.products_name,
            SUBSTRING(`pd`.`products_description`, 1, 100) AS `products_description`,
            p.products_price,
            p.products_image,
                   p.products_model,
                        p.group_permission_1,
            p.products_date_added,
            p.products_tax_class_id,
            s.specials_new_products_price
            from (products p INNER JOIN products_description pd ON p.products_id = pd.products_id) LEFT JOIN specials s ON p.products_id = s.products_id
            where p.products_status = '1'
            and pd.language_id = '2'
            and IF(s.specials_new_products_price>0, s.status = '1', '1')
            and IF(s.expires_date>0, s.expires_date>now(), '1')
                         ".$group_check."
                         ".$days."
            order by
            p.products_date_added DESC
            LIMIT 0," . $product_count ;