ÓÃSQL¶ÁÈ¡Êý¾Ý¿ØÖƳ¤¶È

select title from news ±ÈÈç¶ÁÈ¡title×ֶεÄÖµ£¬³¤¶È³¬¹ý20¾ÍÓá°...¡±±íʾ£¬ÓÃSQLÓï¾äÔõôд°¡

---

select
case title
when len(title)>20 then SUBSTRING(title,0,19)+'...'
ELSE title
END
form news

---

×î½üÐÜèÌرð¶à°¡
ÒòΪÐÜèÈÝÒ׳ö¹úµÄÔµ¹Ê£¿

---

select (case title when len(title)>20 then substring(title,0,19)+'...'
ELSE title END) as title
form news

---

1Â¥¿ÉÒÔ£¬

ÁíÍ⣬»¹¿ÉÒÔд¸ö¹«¹²µÄ·½·¨£¬½ØÈ¡Ö¸¶¨³¤¶ÈµÄ×Ö·û´®²¢¼Ó...,È»ºóÔÙÐèÒªµÄµØ·½µ÷Óá£

±ÈÈ磺

public static string CutString(string input,int MaxLength)
{
  if(input.Length>MaxLength)
  {
      return input.SubString(0,MaxLength)+"...";
  }
  else
  {
    return input;
  }
}

---

ÒýÓÃ

select (case title when len(title)>20 then substring(title,0,19)+'...'
ELSE title END) as title
form news

ÏÔʾ´íÎ󣿣¿
ÏûÏ¢ 170£¬¼¶±ð 15£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
µÚ 1 ÐÐ: '>' ¸½½üÓÐÓï·¨´íÎó¡£

---

ÒýÓÃ

×î½üÐÜèÌرð¶à°¡
ÒòΪÐÜèÈÝÒ׳ö¹úµÄÔµ¹Ê£¿

ÄãÒ²²»Àµ°¡

---

´ó¿É²»±ØÕâÑù Èç¹ûÂ¥Ö÷Òª×öweb³ÌÐòÖ±½ÓÔÚcssÀïÉèÖÃÑùʽ¾ÍÄÜ´ïµ½Õâ¸öЧ¹û

---

SQL code

---

Code highlight