截断文本并添加省略号PHP SQL

function truncateText($text, $length) {
    if (strlen($text) > $length) {
        $text = substr($text, 0, $length) . '...';
    }
    return $text;
}

$text = "这是一段很长的文本，需要截断并添加省略号。";
$truncatedText = truncateText($text, 10);
echo $truncatedText;

SELECT 
    CASE
        WHEN LENGTH(text) > 10 THEN CONCAT(SUBSTRING(text, 1, 10), '...')
        ELSE text
    END AS truncated_text
FROM your_table;