How to truncate string length in MySQL?

2 years ago
Benjamin Taylor
1 minute

MySQL offers several functions for extracting the length of a string:

  1. The SUBSTRING function extracts a specified length of characters from a string starting at a specified position. For example: SELECT SUBSTRING(‘Hello, World!’, 1, 5); will result in ‘Hello’.
  2. LEFT function in SQL is used to extract a specified number of characters from the beginning of a string. Example: SELECT LEFT(‘Hello, World!’, 5); This will result in ‘Hello’.
  3. Extracts a substring of a specified length from the end of a string. Example: SELECT RIGHT(‘Hello, World!’, 6); Result will be ‘World!’.
  4. The MID function extracts a specified length of characters from a string, starting at a certain position. For example: SELECT MID(‘Hello, World!’, 8, 5); will result in ‘World’.

Note: In MySQL, the indexing of strings starts at 1.

bannerAds