select id, case when len(News.title) > 10 then
SUBSTRING(News.title, 0, 6) + '...'
else
SUBSTRING(News.title, 0, 6)
end as title
from News
长度大于10的时候...
最新推荐文章于 2018-06-30 09:38:34 发布
select id, case when len(News.title) > 10 then
SUBSTRING(News.title, 0, 6) + '...'
else
SUBSTRING(News.title, 0, 6)
end as title
from News