SUBSTRING()

1. SELECT SUBSTRING('Hello World', 1, 4);
2.  
3. SELECT SUBSTRING('Hello World', 7);
4.  
5. SELECT SUBSTRING('Hello World', 3, 8);
6.  
7. SELECT SUBSTRING('Hello World', 3);
8.  
9. SELECT SUBSTRING('Hello World', -3);
10.  
11. SELECT SUBSTRING('Hello World', -7);
12.  
13. SELECT title FROM books;
14.  
15. SELECT SUBSTRING("Where I'm Calling From: Selected Stories", 1, 10);
16.  
17. SELECT SUBSTRING(title, 1, 10) FROM books;
18.  
19. SELECT SUBSTRING(title, 1, 10) AS 'short title' FROM books;
20.  
21. SELECT SUBSTR(title, 1, 10) AS 'short title' FROM books;
22.  
23. SELECT CONCAT
24.     (
25.         SUBSTRING(title, 1, 10),
26.         '...'
27.     )
28. FROM books;
29.  
30. source book_code.sql
31.  
32. SELECT CONCAT
33.     (
34.         SUBSTRING(title, 1, 10),
35.         '...'
36.     ) AS 'short title'
37. FROM books;
38.  
39. source book_code.sql