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