- LEFT 返回字符串中從左邊開始指定個數(shù)字符
LEFT(character_expression,integer_expression);
- RIGTH 返回字符串從右邊開始指定個數(shù)字符
RIGHT(character_expression,integer_expression);
SELECT LEFT('abcedf',3); -- 返回從左側(cè)數(shù)前 3 個字符,第二個參數(shù)不接收負(fù)數(shù)撑瞧,會報錯
SELECT RIGHT('abcedf',3); -- 返回從右側(cè)數(shù)前 3 個字符
SELECT * FROM Subject WHERE ID=4;
SELECT *,LEFT(Description,10) AS New_Description FROM Subject WHERE ID=4;
SELECT *,RIGHT(Description,10) AS New_Description FROM Subject WHERE ID=4;
image.png