How to achieve specified character truncation in MySQL?

In MySQL, you can use the SUBSTRING function to extract specific characters. The syntax of this function is as follows:

Extract a portion of the string starting from a specified position and with a specified length.

In this case, str is the string to be extracted, start is the beginning position, and length is the number of characters to be extracted.

For example, to extract “World” from the string “Hello World”, you can use the following statement:

Choose only 5 characters starting from the 7th position in the phrase ‘Hello World’.

The output of the program is “World”.