REPLACE()

1. SELECT REPLACE('Hello World', 'Hell', '%$#@');
2.  
3. SELECT REPLACE('Hello World', 'l', '7');
4.  
5. SELECT REPLACE('Hello World', 'o', '0');
6.  
7. SELECT REPLACE('HellO World', 'o', '*');
8.  
9. SELECT
10. REPLACE('cheese bread coffee milk', ' ', ' and ');
11.  
12. SELECT REPLACE(title, 'e ', '3') FROM books;
13.  
14. -- SELECT
15. -- CONCAT
16. -- (
17. -- SUBSTRING(title, 1, 10),
18. -- '...'
19. -- ) AS 'short title'
20. -- FROM books;
21.  
22. SELECT
23. SUBSTRING(REPLACE(title, 'e', '3'), 1, 10)
24. FROM books;
25.  
26. SELECT
27. SUBSTRING(REPLACE(title, 'e', '3'), 1, 10) AS 'weird string'
28. FROM books;