MID()函数用于从文本字段中提取字符。
SQL MID() 语法
SELECT MID(column_name,start[,length]) FROM table_name;
演示数据库
示例
SELECT MID(name,1,4) AS ShortTitle FROM Websites;
参考:
https://www.yuque.com/docs/share/f3f3bbd1-b80d-44eb-bc7a-26803618bda2