What is the method for string truncation in MySQL?

In MySQL, you can use the SUBSTRING function to extract a substring from a string. The syntax is: SUBSTRING(str, start, length) where str is the string to be extracted from, start is the specified starting position (starting from 1), and length is the specified length to be extracted. For example, to extract characters 2 to 5 from the string “Hello World”, you can use the following statement: SELECT SUBSTRING(“Hello World”, 2, 4); This will return the string “ello”.