SELECT SUBSTR('Hello World', 1, 5) AS Result;
输出结果为:Hello
SELECT SUBSTR(column_name, 3) AS Result
FROM table_name;
SELECT SUBSTR(column_name, 3, 5) AS Result
FROM table_name;
SELECT SUBSTR(column_name, 3) AS Result
FROM table_name
WHERE column_name LIKE '%pattern%';
SELECT SUBSTR('Hello', 1, 3) || SUBSTR('World', 1, 3) AS Result;
输出结果为:HelWor
亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>
推荐阅读:SQL中substr函数的用法是什么